-
Formula to calculate the difference between two numbers based on a month in another column
I am unsure if it is possible to do what I want, but I wanted to ask. I have attached a copy of my grid. I want a formula to calculate the difference between the largest and smallest numbers for each well for each month. For example, for well #2 in month one, find the largest number (58650300) and subtract the smallest…
-
Perpetual Contract Renewal Formula
Hello All! I am trying to create a formula that will automatically update the end date to a contract based on a renewal timeframe. For example, Contract Start date 12.31.19, Contract end date 12.31.20 at the end of the contract, the contract will renew for 1 year perpetually on the same date. Right now we are at 11.8.24,…
-
Subtraction formula with conditional IF statement from cells populated from index match
Hi everyone, I'm trying to create an inventory spreadsheet that auto calculates the QTY in the warehouse by subtracting the amount received from the amount signed out. These columns are populated via an index match formula cross referencing another sheet. I also need there to be the caveat that if nothing has been signed…
-
Automation for creating a Template of new child rows when a Parent is copied from another sheet?
I'm working on creating some workflows that will copy information from a change order tracker sheet into a resource assignment tracker sheet. Ideally, I'ld like to grab key details from the change order tracker (number & name) over to a resource assignment tracker, then have additoinal rows added on the resource assignment…
-
Sheet Title Formula?
Does anyone know if there's automation or a Formula where I can pull the Sheet Title into? For example, I want to create a "Project Name" column in a template that will bring the Sheet Title down to the row level. The use case is to then have a dashboard/report that will combine all my project sheet tasks into one. I know…
-
Number column with leading zeroes
I need a way to keep leading zeroes for numbers in a column, but also keep them in number format for sorting purposes. These are test codes so leading zeroes are necessary but Smartsheet kept converting them into text.
-
Countifs f-la
Hello, to this formula how would i add another sheet to get the match from? this formula says: match employee name, and if the column (sheet 1) has this document title return green, if it doesn't return red (sheet 2). Now i would like it to do the same thing but from a different sheet and return to the same sheet?…
-
Countifs formula
Hello, to this formula how would i add another sheet to get the match from? this formula says: match employee name, and if the column (sheet 1) has this document title return green, if it doesn't return red (sheet 2). Now i would like it to do the same thing but from a different sheet and return to the same sheet?…
-
TIP: Calculations on an AutoNumber Column
I've noticed when trying to run formulas on my AutoNumber column, that it doesn't always work. Here's a table of some of the results. For each row I changed the autonumber "Numerical Places" from 0 to 00 to 000 to 0000. You'll see that the results conclude that Formulas on an Auto Number column MUST USE SINGLE DIGIT…
-
How do I pull the fourth, fifth and sixth name from a multiple-contact column?
In Smartsheet I have a contact column (Project Support) that can have up to six contacts (first name + last name), for example Jane Doe. I then have six other Test/Number columns that pull the first contact, the second contact, the third contact, the fourth contact, the fifth contact and the sixth contact. The first…