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 se…
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…
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 c…
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…
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 Custo…
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 custome…
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”…
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 =COUNTI…
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 Sta…