Formulas
Discussion List
- Hi there! I want to be able to assign a unique serial number to each newly populated row. One of the columns, "Type", determines the first letter of the serial number for the respective row - the pref…
- May 23 2023 02:53PM This is how the date looks when it comes in, (it is pulled in from a 3rd party software via data shuttle). Trying to convert this into a helper column in this format: 5/23/2023 (re…
- The formula works, but it is not solving the equation and is giving me the words of the equation instead =IF([Per Diem Eligible (Yes/No)]@row = "Yes", "25*[# Nights]3", "")
- =COUNTIFS({Consumer Alerts Sign-up Form Date}, >=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY()), YEAR(TODAY())-1), 7, 1), {Consumer Alerts Sign-up Form Date}, <=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY())+1, Y…
- Hi All, I am managing a material tracking sheet and I need a little bit of help with the following: I need a formula (or some method) to sum values of cells in a column called 'Qty'' based on the info…
- This discussion has been merged.
- I am pretty advanced when it comes to smartsheet and formulas. But this one has me stumped. I am trying to find a way to report on the difference between two text or multiselect cells. Any advice woul…
- I'm trying to make new rows copy the cell in a column under a parent but this doesn't seem to function. Am I missing something? When I run this, it posts '=Parent() which doesn't help me.
- I am pulling in data from another sheet based on conditions in the sheet. I can't figure out how to hide the formula error if the value from the other sheet is blank. There will be many cells with bla…
- I have a sheet that has a Task Name column which has Parent and Child rows. I have another column "Levels" that tells me the level that each row sits in the hierarchy. My formula does everything excep…