根据星期几动态更改列表 [英] Dynamically changing list based off day of week

问题描述

你好

我正在尝试创建一个电子表格列表，以显示一周中每一天(周一至周五)的名称列表.每个唯一工作日的名称不会更改，并且每个新星期都保持不变.

I am trying to create a spreadsheet list that displays a list of names for each day of the week, Monday thru Friday. The names for each unique week day do not change and stay the same each new week.

例如，星期一将返回:

艾米

杰夫

萨拉

它将在星期二返回:

开

乔伊

标记

我们无权使用设计器模式，我希望电子表格尽可能简单，提取今天的日期并从中获取星期几，并与硬编码的列进行比较分配给每个人的星期几 到.理想情况下，我不想每周手动在电子表格中复制一百万次以填写日期，因此我可以过滤列表，以便在[今天]显示第1列等于2/1/18的列表. ;我很想做一个if if声明 -如果是星期一，则显示此内容.如果星期二显示此内容.如果有帮助，我对基本的JavaScript很满意！

We do not have access to designer mode, and I'd like the spreadsheet to be as simple as it could, pulling today's date and grabbing the Day of the Week out of it and comparing to a column that is hard coded with the day of the week each person is assigned to.  Ideally I do not want to have to copy each week a million times in a spreadsheet manually filling in a date, I can filter my list so that on [today] it will display the ones that column 1 equals 2/1/18.  I would love to do an if then statement - if monday, display this. if tuesday display this.  I am comfortable with basic JavaScript if that helps!

非常感谢您！

推荐答案

您好，Pasci-不确定为什么要在电子表格中使用它，但是有很多不同之处完成您想要的方法.

Hi Pasci- not sure why you need this in a spreadsheet, but there are different ways to accomplish what you want.

1.列出名称和日期，然后根据日期过滤结果.

1. Make a list with the names and days, then filter the results based on the days.

2.将列表连接到电子表格.

2. Connect a list to the spreadsheet.

这篇关于根据星期几动态更改列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！