-
Formula Not Operating Properly
Hello, I am testing out the Construction/Facilities Management Template Set and I think the formula is incorrect in the sheet for the Schedule Health. =IF(State3 = "Complete", "Green", IF(AND(State3 <> "Complete", TODAY() > [End Date]3), "Red", IF(AND(State3 = "Not Started"), "Blue", "Yellow"))) The way it is currently…
-
¿Cómo calcular los días de retraso entre dos fechas??
Hola comunidad!!! necesito calcular los días de retraso sobre las actividades de mi equipo de trabajo, para ello necesito poner la fecha actual y restarle la fecha de limite, pero no encuentro la manera correcta de hacerlo :( alguien ha realizado algo parecido que pueda apoyarme por favor?
-
Trouble filtering 'old' rows based on an AND condition
Hello, I have a sheet with a Modified (Date) column and another column with a status indicator in the form of a dropdown menu. I am trying to make a filter that shows all rows where the Modified (Date) date is 100 days in the past AND a specific option (stand-by) in the dropdown menu has been selected. I have tried using:…
-
Using IF and CONTAINS in one formula
I am trying to create a formula that returns: Tolerable if the answer is Low Tolerable if the answer is Medium Acceptable if the answer is High Acceptible if the answer contains Urgent. I need to figure out how to use "CONTAINS" because some answers have dashes and other things that mess up the formulas. =IF(Answer@row =…
-
Date Formula Issue: #Invalid Value
I am a complete novice and I have been tasked with fixing someone else's formula. I have seen a number of responses to similar problems with other people but their solutions are not working for me. My formula is supposed to calculate a date 3 months later. For example, in column 1 the date is 10/01/2021. In column 2, the…
-
=COUNT(DISTINCT(COLLECT formula
Hi, I have a =COUNT(DISTINCT(COLLECT formula that is working in my sheet summary area. However when I try to recreate it in a metric sheet that pulls data from my sheet it only counts 1. Here is the formula that is working in my sheet summary. =COUNT(DISTINCT(COLLECT(Customer:Customer, [Who is your audience]:[Who is your…
-
Status Report Red, Yellow, Green for Current Week on Dashboard
Hi there, I'm trying to build a formula to pull in the current week project status and include that in a widget in the project dashboard. Our status reports are done weekly and include multiple workstreams. I only want to pull in the current week status for the Project Management workstream. Example: Project Management…
-
Help w/multiple if statements
Hello! I am a new Smartsheet user trying to figure out if multiple if statements work with what I'm trying to do. I would like to automate the date in the Release to SGS/Printer column based on what is in the Materials in House column and Printer column. The Materials in House column has pre-populated dates I manually…
-
Hi! Not great at formulas here :)
Trying to get the formula to populate tiering (None, T1,T2, or T3) based on the cabinet total using greater than, less than ranges. =IF([Column5]12 > 55 < 91, "T3", IF([Column5]12 > 91 < 121, "T2", IF([Column5]12 > 121, "T1", IF([Column5]12 > 55, "None")))). What am I messing up?
-
#circular reference
Hi everyone, I am still learning the way of smartsheet but I do feel that I have a good general understanding of how it works. I am currently struggling with a circular reference that just wont go away. Well sometimes it does. Here is what happens: I have 2 sheets one sheet is called controls and the other sheet is a…