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…