-
Big Time Saver: You Can Now Add Page Permissions in WorkApps
Hi Community, Are you tired of having to manually go into each role and set individual permissions whenever adding a new page to WorkApps? Not anymore! Smartsheet’s new features now allows users to set permissions whenever they add a new page in WorkApps, reducing the number of clicks it takes to change role settings as…
-
Date Modified
I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific date. I have a Report that uses the 'is greater than-date modified' but I get results from all…
-
Estimate Date Planned against the target date
I need to calculate the planned date against the Go-Live date for each column. The dates are above the columns that should be prior to the Go-Live Target which is 10/31/22. I need to make the actual columns cells yellow for 3 dates against the planned date, red at the planned date. If a date is entered in actual column,…
-
Count time between dates in Weeks/Days
How would I calculate the time between two dates (start and finish) in Weeks and Days "8weeks 4days"
-
Match all columns to complete
I have several columns with dropdown (Complete-Go, Incomplete, TM Approved-Go) and one column that says (Go/No Go). If all columns have "Complete-Go or TM Approved-Go" the column (Go/ No Go) should be "Go" If any column has "Incomplete" the column (Go/no Go) should be "No Go" I appreciate your help very much! Rob
-
How to put a value for each item in dropdown list
I have a dropdown list and I want to put a value for each item (but not in the list): Not Ordered = 0% complete Ready to Order = 1% complete Order Process = 20% Shipped = 50% complete In Country Customs = 80% complete Delivered = 100% complete Cancelled = 100% complete This is to help me to calculate the task % complete…
-
Conditional Formatting Duplicates
Hello, Is there a way to conditionally format duplicates if a value is in a column and if a box is checked? I need this to look through the whole sheet where there are many input values by the customer via a form. Thank you. Brian
-
How do I count the entries from a column from another smartsheet?
I need to count total entries from another column from another smartsheet minus out scope criteria. i.e. 1st Smartsheet, column 1 Title “Total Sites in Scope” 2nd Smartsheet, Column 1 Title “Site IDs” that has entries. Column 2 Title “Order Status” dropdown option “out of scope” Solution: 1st Smartsheet, column 1, cell 1…
-
How do I make the cell to change data after other cell is populated?
I have sheet 1 with the rows below with formula in: LAN Migration Ready =COUNTIF({sheet 2 name Range 10}) LAN Migration Ready Approved =COUNTIF({sheet 2 name Range 11}) LAN Migration Scheduled =COUNTIF({sheet 2 name Range 12}) LAN Migration Complete =COUNTIF({sheet 2 name Range 13}) Sheet 2 I have: Each row represents a…
-
Status Rollup to Parent
I've seen some very similar solutions to my problem, but not quite what I am looking for. My Smartsheet plan has a status column and is using dependencies. My choices in the status column are (Not Started, In Progress, At Risk, and Complete). I would like to create a formula that automatically rolls up the parent of each…
