-
Can multiple form entries populate one row?
Use case: A team lead submits a form reporting a start time for a delay in work, giving information about the delay and crew members involved. Later, the team lead submits another form reporting the end time of the same delay. Is it possible to have multiple entries populate the same row so the team lead doesn't have to…
-
Can you help me finding my syntax error?
=IF(AND(Statut@row <> "Terminé", ([Date prévue de l'événement@row] <= TODAY(-5), "Rouge")); IF(Statut@row = "Terminé" ,"Vert", "Jaune")) What I want is: If Statut@row is not "Terminé" and the [Date prévue de l'événement@row] is equal or less than 5 days before the event, then "Rouge", If Statut@row is "Terminé", then…
-
Date+days not calculating correctly
Hi all, I need to add 21 days to a date referenced in another cell. Ex: 10/15/23 When I use this formula: =DATE(YEAR([Projected Start Date]@row), MONTH([Projected Start Date]@row), (DAY([Projected Start Date]@row)) + 21) I receive an #INVALID VALUE If I hardcode the date into the formula (=DATE(2023, 10, 15)+21, I return…
-
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")))