-
Formulas
I have a sheet created in which specific employees are awarded bonuses on. Those marked as completed would receive a bonus. So I need the formula for Status, assigned, Job # and address
-
Custom Serial Numbers
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 prefix - and the suffix is a three digit number (starting at 001) that increments by 1 determined by the prefix. For example: In…
-
Extract date from cell into helper column
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 (removing the time stamp) so that I can us it in a report. Any help is greatly appreciated. Thank you, Brandon
-
I am trying to create a formula - If I Select "Yes" then multiply 25 by a specific cell.
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", "")
-
What is wrong with this COUNTIFS formula?
=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, YEAR(TODAY())), 7, 31), {Consumer Alerts Sign-up Form Range 1}, @cell = "") I am trying to create a COUNTIFS formula for each…
-
Formula to sum values based on multiple cells.
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 in 3 other columns. So the formula will find all the rows with where the PO No. cells match and the Material Description…
-
Find Difference between two Cells that could be Multiselect Dropdowns or Text
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 would be much appreciated.
-
Do formulas not work in automation?
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.
-
Remove Formula Error if blank
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 blank values and a few that have values to pull in and the formula errors overwhelm the sheet. Formula I'm using:…
-
Join Ancestors help
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 except include the data for task names that are at Level 4. I cannot figure out where I am going wrong. Any help is greatly…