-
What is the best way to combine these 2 formulas and simplify it.
=IF(SPECIES@row = "Roses", IF([TYPE OF POT]@row = "LPD", IF(PINK@row = "", IF(RED@row = "", [Type]@row / 72, (PINK@row + RED@row / 4) / 72)))) =IF(SPECIES@row = "Roses", IF([TYPE OF POT]@row = "LPS", IF(PINK@row = "", IF(RED@row = "", [Type]@row / 36, (PINK@row + RED@row / 4) / 36))))
-
Ways to see total duration in months
I'm looking for a way to see the total duration of a project in months. I've found the NETDAYS formula, but the unit is days, not months. Is there a way around this?
-
Is there a formula to restrict counting ID once?
In my sheet, I have a column that counts the number of extensions for each request. I would like my sheet summary to show the number of of requests that have been extended once, twice, three times, etc. The number of requests extended once was easy to formulate since the request is only referenced once (=COUNTIF([Number of…
-
Conditional formatting not working with certain portion of a formula
Hello all. I have a date column that is populated via a formula, referencing other cells within the same sheet (both date and drop downs). Before I changed this column to populate via a formula, I had simple conditional formatting based on if date was in the past (red) or in the future (green). Since I added the formula,…
-
Nested and/or formula
I am trying to set an at risk flag when a date is in the past and the status is not cancelled or complete. I have used the following formula in Excel and it works, however, I cannot make it work in Smartsheet. Any advice? =IF(AND([Due Date]@row < TODAY(), OR(Status@row="Cancelled", Status@row="Complete")), 0, 1)) I did get…
-
Count entries made the previous week
Hi, I am looking to create a sheet summary formula that will count all entries on a sheet that came from the previous week. I figure that it will have to be a countif formula and will incorporate weeknumber but I am lost on how to count from the previous week and have it keep updating for the next week.
-
Has anyone created an activity dashboard?
Hola Comunidad, alguien a intentado o a creado un dashboard sobre un reporte de actividades asignadas al equipo de desarrollo teniendo en cuenta tiempos de iniicio, final y status de actividad (completo, en proceso, pendiente, atrasada)??? alguien??? ** Translated via Google Translate ** Hello Community, has anyone tried…
-
Is there a way to count the number of dates in a cell?
I want to include a column that indicates the number of times the due date has been extended, but not sure what would be the best way to do this. The "Fulfillment Due Date History" Column on my sheet has a cross-sheet formula that lists the various due dates if they have changed. Could a formula be set up to count the…
-
JOIN and COLLECT
This discussion was created from comments split from: dropdown multi-select and lookups -- vlookup, join, collect, index, match???.
-
"Status" column to reflect 2nd column input for "Cancelled or On Hold"
I have a Status column that is calculated via an IF statement referencing two other columns, [% Complete] and [Cancelled / On Hold]. =IF([% Complete]@row = "", "", IF([Cancelled / On Hold]@row <> "", [Cancelled / On Hold]@row, IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started")))) I…