-
How to start counting the number of days up from a [Start Date] column, but ending it when the job i
Are you able to provide a formula that will for for the following: to start counting the number of work days up from a [Start Date] column, but ending it when the job is completed (whether is be an action or another date is reached)? Much thanks
-
Need a conditional formula to automate status column based on values in date columns
Here's a screenshot of a very simple sheet I've set up where I've manually set the Status. I want to automate the value selection from the "Status" dropdown based on the presence of dates (Actuals) in my Start and End columns: * If the Start and End columns are blank, Status is "Not Started" * If Start has a date and End…
-
automate RYG balls
I'm a smartsheet newbie and i'm ultimately trying to build a formula that automates task progress based on the following: If % Complete = 100, return Blue If it’s not scheduled to start yet, return Clear If it’s past the scheduled finish date, return Red If % complete >= (today date-start date)/task duration, return Green…
-
Using nested MATCH/INDEX across multiple columns
Hi, I'm using two sheets to track the distribution of transportation gift cards, one will be a master list of the cards and the other is a webform tracker that distribution partners use to log who receives cards. I want the master list to check off each card given out after it is logged into the tracker, however each…
-
Status and % Complete co-dependency formula
Hi there, I am trying to figure out how to get Smartsheet to automatically change "status" column to "Completed" when I enter 100% in the "Complete" column, as well as to "Started" when I enter any % higher than 0%, and to "Not Started" if the % is 0. Is there a way to do this? Thanks!
-
Formula Help
Hi All, I am in need of some formula help! 1. I would like to count all of the projects in my portfolio that are in the Active state and either Yellow or Red health. I have a Dropdown List column for State and a Symbols column for Health (RYGB balls). This is the formula I've have been trying. I am getting the Unparseable…
-
JOIN text function over multiple ranges
I am trying to create a formula that will join a group of element IDs from two entire columns. My latest failed attempt is below: =JOIN([Element 1 ID]:[Element 1 ID], [Element 2 ID]:[Element 2 ID], ", ") I'm not sure if I just have the syntax wrong or if the JOIN function is not capable of including multiple ranges. I…
-
Automated way of counting number of cell changes?
Hi all, we'd like to track the number of times a cell was edited in order to capture how many times we've moved out a date on any given project. I'm thinking this isn't possible with a formula, but has anyone found a solution with automation/integration or something else? We'd love to avoid updating this manually and the…
-
Why won't my Nested COUNTIFS work?
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 #Incorrect Argument Set?) =COUNTIFS({Finish}, >TODAY({PctComplete}, <1)) If you care to, I'd appreciate answers to a few additional…
-
File name of the sheet in a cel?
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, Eric.