-
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…
-
Status update from daughter rows
Hi Smartsheets Team, I have a column "Status" that has mother and daughter rows. I am wanting the mother "Status" to update when the daughter rows change. So for example APQP would be "Not Started" until Pre APQP or MFG Plan Review is marked as "In Progress" then APQP becomes "In Progress". When BOTH are marked complete…