Hi everyone. This is my first new discussion. I wanted to share some automation I put into my schedule that made it much more friendly. First, I have a few key columns: * Status (Drop-down, manual ent…
Hello I have been using Smartsheet for quite a while however I am really stuck on this formula. I've been searching and reading and none of the things I have found work and I'm thinking it should be t…
I'm trying to automate the RYG circles according to several columns of a Smartsheet grid for project management purposes. The logic is below (I've also attached a visualization of the logic): IF [Prop…
Hoping the community can assist! These two COUNTIFS work separately. =COUNTIFS({Finish}, >TODAY()) =COUNTIFS({PctComplete}, <1) But why isn't it working when I nest them together? (it returns #Incorre…
I have found quite a bit of useful information to make Nested If statements; however, they are set-up to be "if this, then that or if this, then that". What I need is: "If this is equal to this, and t…
We are trying to achieve a formula that finds the most current Tracked task's Variance from the Baseline date. Tasks are arranged in a table/schedule in step by step order. I'm having an issue with th…
Hello all, Maybe simple question, but I would like to have the a cel inside a smart sheet filled with the filename of the sheet? How can I do this easy? e.g. CLIENT-001-sheet011 in a cell? Thanks, Eri…
Hi there, I love Shartsheet, but one constant aggravation for me is the inability to merge cells. In my quest for a solution, I've come across a few posts on the blog (some as old as 2015) where simil…
Hi, Are you able to help? I have a column named "snag" which is a red flag check box, then another column named "PM" with drop down name initials I need a formula that calculates, when a Red flag is r…
I'd like to filter to show "Open tasks and recently closed tasks". I have this working but "recently closed tasks" is hard coded to ">= March 1, 2017". Can I use a formula for this? I tried to use "=T…
