-
Prevent ID reassignment if RAID Type changes except for existing row
I am currently using the formula below to auto-create IDs based on the Module, Subworkstream and RAID Type of each item in my sheet. The problem that I am having is that if the RAID type changes, it resets every ID in the list. How do I prevent that from happening? Hoping for some guidance. Thank you!!! =[HELPER COLUMN:…
-
How to delete a Level 2 child row itself, indented under a parent?
Hey guys, As per the question title, I'm trying to delete a Level 2 child row itself, indented under a parent When I do this, it deletes all the milestones, project plan data below it :( When I ask Smart Assist, it says it is safe to do so without losing any data - but having done this manually it deletes everything and I…
-
Can I create a dependent dropdown in a Smartsheet Form?
I’m trying to set up connected columns where the options available in a second dropdown are dependent on the selection made in the first dropdown. For example: Question 1: Workstream Clinical Operations Finance Question 2: Topic If Clinical is selected → show only Clinical topics If Operations is selected → show only…
-
Adding up Hours
How would I go about writing a forumula to calculate the numbers of volunteer hours for a specific month and location. For Example: I'd like to know how many Total volunteer hours Lebanon - ED1 had for the Month of August. Thank you!
-
Best Way to Track Individual Approvals/Rejections from Multiple Users in Smartsheet?
Hi everyone, I’m working on a project where we’re looking to improve an existing process workflow in Smartsheet, and I’d appreciate some guidance on the best way to structure this. What we’re trying to accomplish For each request/item, we have approximately 10 different users who need to independently review the request…
-
If Condition Formula - Based on the Previous Row status
Hello Team, I need to write a logic between 2 rows. The formula should be based on the previous row status. How can we achieve this in the Smartsheet ? Here is the example. 2 teams involved. Developer and Approver. The Approver Status need to be changed based on the previous team task status. For both team, we have a…
-
Move project rows if all descendant rows are complete
Hello! I'm fairly new to Smartsheet and I'm working to set up an automation to move project rows to an archived sheet once everything for the project is complete. I'm hoping someone can help me out with a specific formula. I have tasks and subtasks under my projects. I want to verify that all project items are complete…
-
Help me fix my formula
Please help! =COUNTIFS([Points Received]:[Points Received], "Incident", [Employee ID #]:[Employee ID #], $[Employee ID #]@row, Date:Date, <=[Today's Date]5528, Date:Date, >=[Incident 24 Months]5528) + COUNTIFS([Points Received]:[Points Received], "Accident", [Employee ID #]:[Employee ID #], $[Employee ID #]@row, Date:Date,…
-
Allow formulas to function in reports
Currently formulas do not update while in a report. If a value changes, you must refresh the report or window to see the updated formula. This creates a lot of confusion since we use reports to gather updates, which results in me being told "your smartsheet is broken" because the formula columns do not update.
-
Returning matching value in subset of rows
I have a sheet with groups of task types that need to be completed for multiple units. The tasks happen in a sequence (always). I am trying to extract the highest Task Name completed for each task type + unit combo to ultimately display it in a dashboard. So for example, the Highest Completed column for the combo of the…