I am trying to get a value when I put in a particular date If a person puts a date in the Target completion field, I want to return a Sprint in the Sprint field. I dont know if I can use the month or …
I am working on a Smartsheet to track invoices for contractors and automatically update how much I need to accrue at the end of the month based on the contractor and average price. Each row in my shee…
Having trouble with the last part - the Status column is a dropdown with 5 options. I want it to count if it meets all of the entity, type of request and then if the Status is Ready for Approval OR On…
Hi everyone, I am currently working on a Smartsheet solution to support a compliance declaration process. The process is straightforward: Prior to every board meeting, a form is sent out to department…
Thank you in advance. I have the formula working that I need which is this: =IF([PO Amount]@row > 100000, "Level 3", IF([PO Amount]@row > 50000, "Level 2", IF([PO Amount]@row <= 50000, "Level 1"))) Bu…
Currently Smartsheet Project uses a default 8 AM time as the start date for each day in a project schedule. Is there a way to change that to 7 AM? I am stuck in creating a formula for that. Also, is t…
Hi all - Need some help with an IF formula Goal: status updates automatically to "Not Started" (when % complete is 0), "In Progress" (when % complete is >0 but <1) or "Complete" (when % complete is 1)…
Hi, I'm in the process of transferring a spreadsheet into smartsheet that splits costs by months, and I've ran into a #DATE EXPECTED error for my formula. I can't change the column type as the formula…
Hello and thanks in advance for any assistance. I have spent a ton of time attempting to solve and am tossing up the flag. I have a sheet that needs minimal column formulas due to the line/cell count …
I have several sheets that are tracking the time a field employee is working at a specific location. This is determined by the Current Date minus Start Date to give me the number of days. I set the ou…