- 条件格式为日期Cell
Hi, I want to apply conditional formatting to a date cell if the date in that cell is earlier or later than a date in another cell. Can someone tell me if this is possible and if so how to do it? Thanks. -Marcia
- Request update only if no recent update exists?
Am I being dense? I can see ways to automate a reminder based on conditions, but in a sheet with multiple submissions from one person, if I want to remind them ONLY if I haven’t received a recent update, I can’t say “don’t send if.” ? I can send a request for update based on “if not in the past” but if there is a recent…
- Priorities within Priority
I have my priorities set up for high, medium, low. I'd like to prioritize within the highs, lows, etc. I'm used to working of an ABC, 123 set up.
- If with dropdown list
I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, country dropdown list will show JP, SG, IN If chose Region AMER, country dropdown list will…
- Dynamically Add columns
Hello, I have a form that was created that we send to a group of individuals asking them to update the status. Currently, the form is formatted as a text box where we are the individual to format the date and add a comment. As you can imagine this doesn't allow for the best reporting. I am curious is there a way to create…
- Free Collaborator / Unlicensed User
Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row. secondly: if Unlicensed User delete row or related information in row how the admin will get to know what happend or what is…
- Filtering/Slicing in Dashbaords
Hello SmartSheets Team, I am a little new to SmartSheets, but I have successfully built a dashboard with all the data I would like. However, I can't seem to find any functionality that allows me to filter/slice the data in the dashboard view, say to specific users or anything like that (for example, I can see total sales…
- COUNTIF with Dates
I am trying to use COUNTIF referencing two Dates columns. The first "Due Date" column has dependencies. The second "Dates" column is simply a list of all possible due dates from the beginning of the project to the end (with no dependencies). I am trying to create a third column called "Total Due" that counts how many tasks…
- Auto order (by date) in Card View
We have a project workload sheet that has columns of who a project is assigned to, completed, and new. There is no sorting or auto ordering of the projects that happen in each column (by start or end date). You can sort rows in the other views, but not card. Help, please.
- Multiple Selection on dropdown
Is the ability to select multiple items from a dropdown still in development???
