-
Auto inputting a date based on a status change
Hi, I want to set today's date in a date column when the status, in a status column on that row, is set to something other than 'open'. I don't want the date to change once it is set so the TODAY() function does not work for me. Is there a function to do that? Regards Mike
-
How to dynamically populate a dropdown box
Hello, I'm new to all of this. I am wanting to have a staff database that is connected to a purchase order database. When a user fills out a form for the purchase order database I want them to be able to select the staff member from a dropdown box that is pulling unique data from the staff database. I cant figure out how…
-
Join(Collect - with IF statement
My Join(Collect statement works on its own but when I try to add the IF statement I get an "Invalid Operation." =IF({NewDeployment} = "1", JOIN(COLLECT({Station2}, {Month}, "1", {Year}, "2020"), ", ")) My "New Deployment" column is a checkbox column and I only want to join/collect the names of the stations where "New…
-
Can two people receive a work request confirmation email?
When a client enters a work request via a form, there is an option to for them to request a confirmation email. Can that confirmation be sent to two different people? For example, support staff usually enters the work request on behalf of the subject matter expert. We have two fields, one is the "POC" (the subject matter…
-
Yet another RANKEQ question! :)
Hello all! I've been diving into Smartsheets, and more recently Dashboards since taking on my new role in Quality Assurance and have come to a roadblock. Goal: I'm attempting to pull a "Top 5 error offenders for yesterday" to display on my Quality Dashboard so it updates automatically. I have a column ("Errors Yesterday")…
-
CountIfs
I am trying to work with a countifs formula. I have a column titled "Event Date" Format MM/DD/YY and a column titled "Risk Level". Values in risk level are "low", "medium", "high". I am trying to count the number of each risk level that occur each month/year. I can get the count for each risk level ok, but adding the date…
-
Update project status column based on the information in multiple columns, using IF, AND, ISERROR
I have a formula using IF, AND, ISERROR, and COUNT in excel (see below), which works. =IF(AND(ISERROR(FIND("Cancelled",AE2&AP2&AY2&BG2,1)),ISERROR(FIND("On-Hold",AE2&AP2&AY2&BG2,1)),K2<>"NSG"),"Stage "&COUNTA(AE2,AP2,AY2,BG2)+1,"n/a") I'm trying to update the formula to work in smartsheet, and have updated to this point,…
-
IF formula with date range that defines a set time period
Statement to solve for - If FINISH date is between x and y dates, the it = 30-60 (time period in a drop down) Formula created, but not working =IF(Finish)42 >=DATE(2020, 12, 21) OR <=DATE(2020, 12, 25), "30-60") Can anyone help solve for this so that I can automated setting a time period based on the task date?
-
Adding another requirement for Countifs formula
I know this should be easy but I cannot get a good return. The current formula I use is as follows: =COUNTIFS({Initial Date - POR}, IFERROR(YEAR(@cell), 0) = 2020, {ROT - POR}, 1) Works fine except I want to add another criteria from the same sheet: (Status, "Closed") And since this is a sheet with multiple years, it just…
-
Count Progress Within a Specific Parent Section
Hello, I am new to Smartsheet so I may not be using the correct terminology. I am trying to count the number of tasks set to a certain "Progress" within my project sheet. Ideally, I would like to break up this count by the different parent sections we have set up (Government Officials, Healthcare & Medical Offices,…
