Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for February 2017
Discussion List
RYGB Status
I've read all of the other posts about this formula, including the Blog, but i can't seem to get this formula right. Here's what I'm trying to do: Due Date TODAY(-5) = Green Due Date TODAY <4>0 = Yellow Due Date TODAY+1 = Red Date Completed = Blue I can get the RYG balls but I can't figure out how to ADD the criteria for…
Master Project Sheet vs Master Project Report
We are looking at implementing either a very large (roughly 160 columns) master project sheet or a master project report. If we go with the master project sheet, teams would work off reports to update their respective data. If we go with the master report, I would aggregate specific data from each team sheet. The end goal…
Expand/Collapse all functionality
I have set up a hierarchy within several sheets and I'm wondering- is there an Expand all/ Collapse all functionality for the 'nested' rows of data? Refreshing the page doesn't change anything within the sheet that is shared across 4 users. Mendy
Formula for Parent, Child, and Non-parent/child rows
I need a formula that encompasses all three of the scenarios listed below. In my case, I have a Project ID system-generated column and a Rep_Project_ID column for grouping related tasks. I want parent rows and non-parent/non-child rows to copy the same-row Project ID and child rows to copy the parent Rep_Project_ID number.…
Triggering a notification based on the dates of two rows
I would like to create a notification to let me know a task will be finishing late, which will impact the start of another. IF the 'Finish Date' of task 'Narrative' is greater than the "Start Date' of task 'Review' send notification You can see in the screen shot that Hillary is going to be impacted on starting her work…
Conditional Formatting less than or equal to
I'm trying to setup conditional formatting so that when a cell has a value of less than or equal to zero, the cell will highlight. Unfortuantely, the is no 'less than or equal to' function. I tried to setup up two rules for less than zero and equal to zero but the problem is, the statements are linked by 'and' instead of…
RYG Formula...
Looking for assistance. I am looking for a formula that adds the total number of individually RYG in a column that automatically populates a separate cell in a separate column. Any guidance would be appreciated. Thanks. - Erik
Comparing offers for the same job from different providers
What is the esiest way to make a spreadsheet for comparing prices?
Counting a cell with any data present
I have two questions here, any and all help would be greatly appreciated. A little background might be useful. Rows in my smartsheet are all considered one video item. A variety of things are tracked in these rows via the columns. 1. Using formulas (specifically COUNTIF OR COUNTIFS), can I count a row that has two columns…
Printing from mobile app
I can't find any option to print on the smartsheet app, specifically for ipad and iphone. Am I missing something? This would be a great option to have.