-
Merged: Formula's to have a user input result
This discussion has been merged.
-
Linked Source Sheet Not Automatically Updating
Hello, I am working on creating a sheet that utilized data from a master sheet via links. I am struggling because the new sheet is not automatically updating when new info is added from the master sheet which essentially makes it useless. Is there a way around this? For what I am trying to create, I need the full…
-
How can I capture the date and time of specific column changes?
I have created a workflow that goes through three different departments. I want to capture the date and time of a request (row) coming in, and the date and time of the next action and each action after that for cycle time purposes. Currently, I can track cycle time for dates but some actions need to be carried out within…
-
How to create a master sheet that can work-around the 20,000 row limit?
Hello Everyone! I need to consolidate data from two large Smartsheet sheets into one master sheet to use as a reference for another sheet. However, Smartsheet's 20,000-row limit prevents me from combining everything into a single sheet. I cannot use Smartsheet Reports as a workaround since reports do not support formulas,…
-
Calculate Age from Birthdate
Hello, How do I calculate a person's age from their birthdate?
-
Keeping Indexed and Non-Indexed Columns on the same Row
I'm making a training matrix for my company. Source sheet is the "matrix" that will list all employees and their required trainings: *RowID is auto-numbered column *RowNo formula is =MATCH(RowID@row, RowID:RowID, 0) *E1 (helper column) formula is =COUNTIFS([Employee1]:[Employee1], [Employee1]@row, RowNo:RowNo, @cell <=…
-
Updating Average of most recent cells?
Hello! Quick question I've been stumped on. I have a sheet that tracks hours worked on different projects each month in a year. I want there to be a cell that displays the average of the most recent 3 months. Of course, I'd want this to update when a new month is entered. That value would be used along with the "hours…
-
Nested ranges in INDEX/COLLECT??
I need to pull in all of the email addresses from a sheet into another sheet so that my workflow can alert the people listed in that cell. I have the cell set up as a contact list allowing multiple contacts. I need to pull all the emails for "Anywhere US" where the level is "Major" into the sheet that has my workflow when…
-
Trying to figure out how to leverage a name to autofill assigned to in children tasks.
I have a sheet where people are picking up open assignments. This is being linked to the master sheet with the Parent and children tasks. I am trying to figure out how the "pick up assignment" can auto fill in the "assigned To" child tasks once the Pick up assignment has been filled out? See attachment for more detail?
-
Formula for Duration Between 2 Date Columns
I need a formula for a duration of days between 2 date columns. I have no idea how to do this, as I am a new smartsheet user and not familiar with coding or formulas. Any help would be GREATLY greatly appriciated!!! Please view attached. Thanks!
