Formulas
Discussion List
- Hello All, I am trying to write a formula on a Status column. the conditions are: Not Started if planned start date is in the future and actual start date is blank. In Progress if actual start date is…
- Hello, Is there a way to sent an automation reminder to be triggered on my project plan for a task when another task's due date is 3 weeks out. For example, I have task A, task B and task C. Task B an…
- I created the formula below and it is working for the section that says "Validations - Issue Validations" and "Validations - Regulatory Issue" part and I can't figure out why =IF([Risk Activity]@row =…
- Hi, I'm trying to use Index/Match to list the mission statement(s) for each selected non-profit from a dropdown that allows multiple selection. The mission statement lives on a reference sheet and I'm…
- Hi all, I am trying to combine a formula converting a numeric value to a specific format with a check for non-numeric values so the non-numeric values are passed through and don't cause an error. I wa…
- Hi Everyone, Can't seem to find much information on this topic can anyone help with the below? Or point me in the right direction. Trying to create an annual calendar with deadlines. The calendar incl…
- Hi! I'm a virtual assistant new to Smartsheet and I was tasked to replicate a skills assessment worksheet template. It uses the symbol (stars) ratings so I can get the average score and the number of …
- Hello, I am trying to get this math equation to work in smartsheet that normally working in excel and can't figure out how to do the proper order of operations. Can anyone help? AN2 is the cell in exc…
- QUESTION: How to create a Text string output from a formula that can be copied and pasted into other applications. BACKGROUND: I have a large project that requires many Discovery sessions and have a s…
- Hi Community: If a task has gone unassigned for >=5 days after initial entry has occurred AND the task has not been assigned to someone, I need to flag the concern and workflow route to a specific ind…