-
Smartsheet overrides workflow approval
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, then it goes to one more and then the director. Problem is that smartsheet is overriding the "Approved" status from…
-
Help on fiormula: countifs
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 for 2018. I'm trying the formula below but I'm getting an #INCORRECT ARGUMENT error. =COUNTIFS(Stage:Stage, [Forecasted End…
-
Days Remaining Calculation
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/18.
-
Number of Days Ticket is Open
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 column that is labled number of days open. How can I have this column automatically display the number of days the ticket is…
-
Dates - Gantt Chart
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 Date column...which I am doing now with =VLOOKUP([Sprint Start]4, $[Sprint Start]$123:$[Sprint End Date]$136, 3, false). The…
-
Best way to calculate stats on a sheet tracking form submissions
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 the issue. Its a tracker you could say. I want to be able to calculate how many of "issue type" A or B have been submitted via…
-
Any updates to "View permissions on individual columns & rows"
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 the request was being noted as a possible enhancement. Has there been any movement on this? I currently have a "Main Sheet"…
-
RYGB
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 to "Sign need date" Here's where I'm not sure on the logic sequence: If "Sign actual ship date" is null - Use projected to…
-
Activity Log - Is there a way to limit who sees it?
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 questions and concerns.
-
Cell to test if an ETA has passed without an order delivery
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 like to extract the order essentials into a report that I can surface to three different managers via a portal/dashboard.…