-
IF/AND/OR Formula for Parent Row
Hello! I'm looking for help to perform the following logic for Parent rows ONLY: If the status of any child row is In Progress, then set the parent row status to In Progress. If the status of ALL child rows is Complete, then set the parent row status to Complete If the status of ALL child rows is Not Started or Blank, then…
-
Errors with Status Ball Formula
Appreciate any/all help! I can’t get past errors: #UNPARSEABLE, #INVALID DATA TYPE, #INCORRECT ARGUMENT SET I'd like to achieve the symbol results in the "Indicator" column based upon entries in "Client Status" and "RCM Status" columns. Thank you! Mary
-
Calculate Age from birthdate
Is there a way to have a cell auto calculate age (years and months) from birth date in another cell?
-
AutoNumber Parent Rows Only
Is there a formula/ methodology to auto number parent rows only, preferably with a prefix style numbering sequence like the Autonumber column type uses?
-
Appointment Scheduler Workapp
I have a requirement where I need customers to book appointments for us to send a technician to their site. We have multiple technicians available but still want to avoid double-booking in the case all technicians are booked on a given day. I've seen similar questions posted before, but none with detailed answers and I am…
-
IF Statement with multiple dates an count.
Hello, I have a large sheet that I am trying to calculate several dates to populate dependent on a Count in a row field (ie - a count of 0 would generate a date being pulled from one column, and a count of one generating a date from another column). Columns in Question: "Was Rejected" - this is a count on either it has…
-
Combine: IF AND CONTAINS, And SUMIF
Hi, I got a question about how to use all the above statements in one formula, _______ I have the following columns; A regular text column "Client ID", A multiple dropdown column "Shared IDs", A regular text column "Hours worked" A regular text column "Shared Hours Approved" _______ I have each client and their Client ID…
-
Last modified for specific cell
Hi! I am trying to figure out if there is a formula to basically look at a cell and see when a specific cell is modified. I am trying to use this for KPIs. For background: I have a workflow where if something is rejected by my engineering department the person who created the request is then triggered to answer…
-
Add Column for Date Record is Closed
I want to create a new column that is a formula. The Status can be blank, Open or Closed. Once a record is closed it will not be reopened. If there is reason to do so, a new record will be opened and it will reference the original. This has only happened once. This date column should be blank unless the status of the…
-
Return checkbox column to initial state after project scoping is complete
I'm trying to figure out if/how I can return a checkbox column to it's original state once a user has completed scoping a project. I've tried just about everything and keep running into roadblocks given my level of Smartsheet knowledge. For context: I've created a project scoping sheet that contains rows for all…
