-
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…
-
How to add multiple IF statements to WORKDAY function?
Hello trying to add multiple cities to a workday function. This is to subtract our ship day from the expected arrive by date. Currently, this is what I have =WORKDAY(F3,IF(OR(K3="CITY1",K3="CITY2),"-2","-10"),Sheet1!B$2:B$49) I want to add 2 more cities. The function can either be from another column/sheet that has the…
-
Average Collect Unique Formula
Hi, I am looking to pre set a data frame for Tableau Dashboards after form submissions and I need to do an average by a unique Risk Area. First a calculated the average Business Unit score for each Risk Area and now I want to take those average scores for each Business Unit in a Risk Area without duplicated values. How can…
