-
Formula to color RYG balls based on date/deadline
Hello, I'm trying to alter the color of our RYG status balls based on the proximity of the date. For example: Yellow - if today's date is within 5 days prior and 5 days after the deadline date noted Red - if today's date is 5 days + after the deadline date Green - if today's date is before the 6 days + before the deadline…
-
Auto Sort
Hello, Is there any way to create automation that will automatically sort a sheet when a cell is updated or changed? Thank you, Sean
-
Row ID (ignoring blank cells)
I am trying to create a sheet which identifies batches of 25 rows and creates a specific batch ID, before moving onto the next 25 rows. (Batch Column) I also need to formula to ignore rows with blanks entries. (Row ID) I hope somebody is able to help
-
Conditional Logic for Header fields in Forms
Hi all, With the new update to Smartsheet forms, we are able to add conditional logic to designated fields within a form. However, I noticed that while you can set logic to only populate designated fields when a certain option is selected, the headers of the fields that are NOT designated under that logic still appear on…
-
Is there a way to set up Cumulative Roll Up Notification Emails
We have a large team all working within a workspace, and they already get a TON of email. Is there a way to set up a single daily notification for new items assigned to team members, without it being an email for each sheet? We have about 10 sheets that are being used, so would prefer not to see users getting 10 emails.…
-
SUMIFS Formula
I am attempting to get the sum of two separate columns Number of Participants Reached (Adults) + Number of Participants Reached (Students) for FY 2021 only All 3 sets of numbers are in different columns I can get the total sum of the two columns right for all years but I can't figure out how to have it only calculate for…
-
Flag is others are flagged
I have an "At Risk" column and I want one row to flag if any in a set range of others are flagged. For example, on a project template, I have a "Planning Milestone"; I want the milestone to flag if any rows within the "Planning" phase are flagged. I was attempting to use a formula like this: =IF([At Risk]95:[At Risk]98 =…
-
Is there a way to refer to another "row" within comments/conversations? Refer to unique rows via URL
As a Smartsheet user, I want to be able to refer to a row when typing a comment so I can better give context and easily give URL's to navigate quickly to the other row. ---------------------- Use Case: I leave a comment on Row 1. Row 1 is named "Product Plan". Within the comment on Row 1, I'd like to quickly refer to row…
-
Project Phases of Development
Hello! I am trying to find a way to show the development stage of a project so it can be rolled into a report. Basically if all of the tasks in a section are complete, then the development stage would be the name of the next header task. For example (see image), if "Project Planning," "Drafting," and "Developing" are all…
-
Can you hide a Report Group's column name?
When you create a grouping in a report, just above each section header is a little grey reminder of which column you are grouped by. This is repetitive and may not useful for people who view the report through a dashboard widget. Is it possible to hide this little grey label? Here's an example:
