-
Update value in cell with value from another cell within the context of automation action 'change value in cell'
@Paul Newcome I have 2 worksheets; Master List of site locations Tracker This worksheet pulls in some data from the Master List, i.e., site name, site address, site contact, etc. using and INDEX/MATCH with the 'Site #' as the unique identifier When the Site Address updates I want an alert to 'send to everyone shared to…
-
Tracking what a Delay is within a Project
This may be a longshot, but I am wondering if there is an easy way to track what a delay is within a project? My best thought would be to make it a manual field within sheet summary that is a dropdown. It would be called something like Project Delay with dropdown selections like: Customer, Supply Chain, Sourcing, etc. Not…
-
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…
-
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:…
-
Merged: Can I create a dependent dropdown in a Smartsheet Form?
This discussion has been merged.
-
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,…