-
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…
-
Formula Needed
Hi Smartsheet Team, I am looking for help with a formula: I have a column "Schedule Health" that has RYG Balls I am wanting this to change color based on certain criteria from 3 other columns "Status", "Start Date", "End Date". Ball is GREEN if "Start Date" is 7 days from today (ie project has not started yet) Ball is…
-
How can I make a multi-IF cross-sheet INDEX formula?
Hi there! I've been stumped on trying to make the correct formula for my situation. Any help is greatly appreciated! In one sheet (Data Collection sheet) I have a column for Sample ID and a column for Results. In another sheet that I'm using to report out, I have a column for the results of each possible sample ID. I want…
