Formulas
Discussion List
- 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…
- Good morning, I am using Smartsheet to track swim time which has a format of minutes:seconds:fractionalseconds (i.e. 5:00.50). I would like to see if anyone has a solution for a couple of issues I am …
- Hello- This is a look up of sorts. I have a list of files. Each time i receive the file it is logged with it's package name and date. I can MAX CHILDREN the date and it rolls up to the PARENT, however…
- Is there a way to have a checkbox automatically checked if other columns with checkboxes get checked? I have 4 columns with checkboxes and instead of doing value columns for each one I would like to d…
