-
Recurring Reminders
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 monthly basis. Thank you.
-
Moving rows and losing formulae links.
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 row change. I have to reapply the formulaes in certain cells which can be time consuming. has anyone else had this problem or…
-
If N/A checkbox is marked note % complete as 100%?
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? Thank you!
-
If And Formula Help
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),([GP Amount]40*5%, IF(AND(([Total Billed]40)>=20000,([Total Billed]40)<30000),([GP Amount]40*10%, IF(AND(([Total…
-
Formula Help with NA
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 usually figure it out. Not this time! This is what is in col 4 cell, but I get Unparseable. =IF(ISDATE([datecol1]7),…
-
Auto Date updating a published report of Events List
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 being part of a Report, which I then Publish to our public website. I would like to include a formula in the checkmark…
-
One Click Task Completion
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: - percent complete goes to 100% - Task status goes to complete - completion date is today - etc
-
The Power of the SUMIFS Function
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 and functions (types of work) that could be charged to. I had wanted to let people select the project they were working on…
-
Calculations in a report
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 Date' in my sheet =ROUND((([End Date]1 - DATE(2015, 1, 1)) / 7) + 0.49, 0) in my report I defined in the 'What' part:…
-
Bug in latest version of SmartSheet
Hello Smartsheet Community, I use the formula : =[Previous Week]1 - [End Date]1 to show me my variance each week when I status my smartsheet schedule. The latested update in Smartsheet broke my formula so that when I copy the "End Date" field into the "Previous Week" field it no longer shows as "0" when th dates haven't…