-
How do I +20
I have a column labeled - "year updated" In the first cell under it I put 2020 from a drop down menu In the next column over and in the cell next to it I want to apply (year updated column cell 1) the (2020) cell and add 20 to that 2020. I have the other column I am trying to populate set up as text/number. So when Iโฆ
-
Backslash not appearing
Hi there. I am trying to write an if formula ( =IF([Question 2]@row = "C:\Desktop", 1, 0) ; however, as soon as I hit enter, the formula gets saved as ( =IF([Question 2]@row = "C:Desktop", 1, 0) ). The backslash (\) in the text between the quotation marks won't appear, so the formula becomes wrong. I don't know why the theโฆ
-
IFERROR MONTH
#UNPARSEABLE error when adding the MONTH function. =COUNTIFS({Incoming Quality 1}, Quality@row, {Intake Sheet Range 1}, IFERROR(MONTH(@cell),0) = 4))
-
Status Updates
Good afternoon gurus! Here is our question of the week! I have a process that follows a material through different stages of release. This process spans across multiple sheets, some sheets containing multiple steps in the process. I had a "status" column requiring manual updates, but time has shown that automation would beโฆ
-
Grouping in Dynamic View
Hello Smartsheet Community! Is it possible to group rows in Dynamic View? We have experimented w/ Report View and the ability to group like data, we would like to have similar functionality in Dynamic View. Thanks in advance! Greg
-
Calculating Time in HH:MM:SS
Hello, I'm hoping someone might be able to help me with calculating time in Smartsheet. We work with production teams in broadcasting, as well as other non-production teams, so calculating time is becoming rather vital, as more and more departments are using Smartsheet for a varying number of use cases: people and resourceโฆ
-
Harvey Balls for Due Date
Good morning, struggling with Harvey Balls this morning and creating a nested IF. My previous version did not take into consideration the status so as the entries aged, they eventually all turned red which skewed my metrics. I am tracking the age of invoices and want to have the following conditions captured by a harveyโฆ
-
Automated RYG Balls
Hi, I'm trying to add an automated RYG light column formula with the following function: Green = [Status] is either 1) "Resolved" or 2) [Status] is "Open" and [Due Date] is in the future Yellow = [Status] is "Open" and [Due Date] is in 14 days or less (including today) Red = [Status] is "Open" and [Due Date] is in the pastโฆ
-
Need help with Harvey Balls and Formula
Hello! I am trying to use the four status Harvey Ball for a training course. I want it to show empty until completing a 3rd exam, 1/4 after completing the third exam, half after completing a 6th exam, 3/4 after completing a 9th exam, and full when completing a field evaluation. I have this so far... =IF([Section 3โฆ
-
IF AND statement with TODAY function
I am trying to write a formula where if the date in the "Date" column is greater than or equal to today AND the "Attended" column checkbox is not checked, then check the box in the "Missed" column box so that a notification will go out to all of those who missed the training. This is what I have that is giving me anโฆ