-
Column Adding up to a certain number
Hello, we are using Smartsheet to process our annual merit for all employees. We have a column for Increase Amount - which will be a number value that the employees salary is being increased by. Since each manager will have a budget for their area, is there a way to set a trigger that if the values in that column go over a…
-
Creating a Formula where there is multiple selections needed.
Good Morning Smartsheet Community. I have been struggling with these formulas for a few weeks now and decided to finally reach out for some help. I am trying to make 2 formulas but there is a part of the formula where I need to reference 2 options in the same drop down. I think I am tripping myself up when it is having to…
-
MAX COLLECT across a range
I am a bit stumped and looking for a little help. I have a forecast sheet with a form where the user has to submit their monthly forecasts for the quarters across five subject areas. I have a column for each quarter and each subject area, 20 columns is my range, Forecast worksheet: Quarters For example purposes please…
-
If(Contains) issue
I am trying to look at a column on one sheet and if it contains a certain value or multiple of the values that I am searching for, return a sum of value(s) from one or more specific cells that are contained in a separate sheet, otherwise return as 0 or as if nothing has happened. This is the formula I have come up with but…
-
Leave field Blank when using IF formula, on Date Row.
Hello, I would be eternally grateful if someone can help me, I have tried ISBLANK, and "" to leave the collum's empty but its not working. I have the IF formula to turn Red when the date is nearing 30 days, Yellow when the date is nearing 60 days, and Green when the date is over 60 days. But some fields will be blank; on…
-
Check a Box when a match is made on two criteria's between two sheets
Can someone assist on how I can revise the following formula so that a check a box is checked when a match is made on two criteria's between two sheets, Contract ID the two date fields. Both the contract ID and date fields are real values (not calculated). However, the formula is returning blank in the 2nd sheet (snippet…
-
Formula to auto increment unique IDs
Referencing the example image below, I'm looking for a formula that will automatically create incrementally numbered unique IDs, like what's shown in the column "Unique device ID within each room". That column's ID needs to be unique to the room number, but the ID is repeated in other room numbers, as shown by COMPUTER1…
-
Date Format Question
Hello Smartsheet Community, How can I get the Date Helper column below to automatically show the date format as D-M-YYYY? There is a formula in that column and it's a date column. When I click on the date format button and select another format type, it does not do anything. The D-M-YYYY format seems to be the only one…
-
Date formula to show when retraining is due based on number of months and/or year(s).
I'd like to be able to use a formula to add either 1 year, 3 years, 5 years etc. to show when retraining is due based on the Training Completion Date. Any suggestions on how to approach or a date type formula that will add one, three, or 5 years to the Training Completion Date would be greatly appreciated.
-
Contains function - leave unchanged unless condition is met
I need to update cell A in each row of a very large sheet only if a certain substring exists in cell B in the same row. If the substring does not exist in cell B, leave the existing value in place, do NOT blank it out. I cannot use any alternative "else" assignment approach because these cells are already populated. In…