Trending in Formulas and Functions
-
Parent Row Status Roll Up
Hello! I'm looking for help on a formula I have yet to find exactly what I am looking for. I have found a couple of others I have been tweaking, but not working exactly how I would like. I'm looking for a formula to roll up the status of children status to the parent row. Here is the breakdown: If all statuses are Not…
-
Copy all Data from one Column in a sheet to another column
Hi , I'm trying to copy all the information from one Column to another Column in a different smartsheet. Can I use Index for this? I see example of index/match but I don't have anything to match. Example Sheet name "Testing" Has several columns one of which is named "ITEMS" Sheet name "Testing 1" Has several Columns one of…
-
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…