I have a multi-step workflow approval set up. Form entry submission sends an initial request to the manager. When manager approves, next approval goes to center administrator. Once that's submitted, t…
Hi all, please need your advice for the correct formula for getting the count of projects that are active within a specific month? We would like to track the number of projects that are still active f…
How do I set a date in the future and then count down the remaining days until that date? For example, my future date is 8/17/18 and each day I want it to show how many days are remaining until 8/17/1…
Hello all. I am a newbiw to Smartsheet, and I'm having trouble correctly adding a formula to one of my sheets. I have a repair sheet with a column that shows the date the ticket was created and a colu…
I'm building out a plan with tasks and dependencies and want the dates to populate based off a vlookup. For example, If "Sprint 12" is selected then the proper start date is set in the Sprint Start Da…
I have a SmartSheet that logs "installation issues" as they are submitted via web form. The sheet tracks the "locations" id number, address, owner, manager, issue, issue type, and who is working on th…
Hello, The original "View permissions on individual columns & rows" was posted in 2016. The end result appears to have been you could not set permissions for individual columns & rows on a sheet but t…
I am trying to develop a formula that will look at multiple columns to return a RYG status. If "Sign work?" is box is checked THEN Look at "Sign projected ship date" & "Sign actual ship date" compare …
Is there a way to hide the activity log from users or limit the view? We make changes to Project Plans especially in the beginning where we don't want a client to see it. It could raise a lot of quest…
Hello, I'm trying to generate a report that shows any orders that have passed their ETA without delivery. In the sheet, I have figured out how to highlight the row with conditional formatting, but I'd…
