-
Multiplying where a field may be blank
Hi! I am multiplying 3 columns + multiplying the next 3 columns to get a sum of the total cost. However, here is an instance where "1455 REP Gallons Used" is blank. I am getting the old Invalid Operation now. Would "if error" fix this and if so, where would it go? =IF(ISBLANK([1455 MU Gallons used]@row), "", IF([1455 MU…
-
Link two cells
Hello everyone, I'm new working with smartsheet and seeing that he does not have all excels formulas. I need to change a "status" when I change a number in a column. For example, when I change the column "Status da entrega" to "Aprovada", the next line change "Status da atividade" to "Liberado" and it is working fine with…
-
Email automation with PARENT/CHILD data from pivot table
I'm trying to create an output of specific rows of a pivot table to attach/include in an automated email. See below for an example table I'd like to extract from the master pivot table. The "Alert someone" automation allows me to specify which cell information I want to include but does not seem to be able to allow for…
-
Giving an output based on text from multiple selection dropdown
Good Afternoon, I've been racking my brain trying to get this function to work. I have a column set up to allow multiple selections of specific text with the column name "Processes." I want the cell to find the specific text and give a number value. I'll then pull from a "Due Date" column giving the processes start date…
-
Help With Multiple If Formulas
Hi, I am attempting (Badly) to put together a formula to set dates based on a previous date, but also the timeline is based on a yes or no answer, so if the answer is yes there is one timeframe and if no there is another I also don't want errors if the field is blank. So far I have this; =IFERROR(IF([Client review…
-
A way to automate status/ progress based on % complete, duration and baseline end date
Sorry if this has been solved previously, and for the long message! I'd like to create an auto status column that is based on % complete, duration and baseline end date for each task. I've added 3 helper columns (image attached), but I'm stuck with the formula for the status: -'Days Complete %' is based on the duration…
-
AND/IF formulas
I'm trying to identify the syntax error in my formula. Can someone help me? =IF(Statut@row= "Terminé", "Vert), IF(AND(Statut@row = "En Cours"; IF(Échéance@row<=TODAY(); "Rouge", "Jaune")))
-
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
