Here is my challenge. I would like to create a formula in a template based on a row's Task Name (Task Name is a column), not the actual Row Number. The Row Number for this Task Name may change from pr…
Is there any way to set recurring monthly reminders for each row for content which doesn't get updated? I am doing up a rental collection sheet, and need to set reminder for the person in charge on a …
Hi there, I use smartsheet a lot to manage and track report issuing between multiple users. I regulary have problems when moving rows to enable organisation by priority and the cell links within the r…
I have a "Not Applicable" and a "% Complete" column. I would like to create a formula that will automatically set the % complete to 100% if the Not Applicable checkbox is marked. Any suggestions? Tha…
Hi I am a new user of smartsheet. I need help on why this excel formual will not work. I get #UNPARSEABLE =IF(([Total Billed]40)<10000,0, IF(AND(([Total Billed]40)>=10000,([Total Billed]40)<20000),([G…
I need help with a formula. I have 3 date columns. If there's a date in datecol1, and a date in datecol2, and either a date or NA in datecol3, then enter 1 in col 4. I am not a programmer, but can usu…
We have an a Smartsheet of Events - tradeshows etc that we will be participating in. While initially developed for internal sharing, I have added a "publish" checkmark column, with those items checked…
Hi All, In Project we invariably have different variants of: - percent complete - Task Status - Completion Date - etc What I am looking for is a way where say I tick a "Complete" checkbox and: - perce…
When I discovered the SUMIFS statement recently it solved a problem that had made me keep things like the project timesheets for our company in a very rigid format that basically listed all projects a…
I'm trying to create a report where i only see records with End Date = this week. (so not 'the coming 7 days' or something, only this week#) I have column 'Week# that shows the week# of the field 'End…
