-
Need formula to evaluate a date field with multiple entries
Hello all, I need help writing a formula that looks at a date field (which may have multiple entries) to see if it contains any dates within a set range. For example: if the "Date" field contains any dates earlier than May 5, 2022, return "1", otherwise, return "0". Here's where I'm at... =IF(CONTAINS(Date@row < DATE(2022,…
-
Earliest Start date on a smartsheet Form
We need 2 weeks to provide service to our customers. If they enter information in a form in smartsheet, how do we indicate the earliest date that they can expect service within the form. So it would be today's date +14 days. Caveat is "Today's date" needs to be static. Thank you.
-
Moving rows/updating cells
I manage a portfolio of projects which I have to report on. I'm a Pro user, so I don't have the functionality that could probably make this task very easy. My project managers are required to use a company solution (not smart sheet to create project plans and updates). I've created a smart sheet that lists all of the…
-
I'm trying to do a subtotal count.
Can I get a count of the number of red shirts, yellow shirts, green shirts, red pants, green pants, etc.? I know I can use countif item=shirt, and color=red, etc. But my actual sheet I'm working with has a very long list of items so writing a formula for each item would be too tedious. Is there a way to do a subtotal by…
-
Is it possible to get a count in Sheet Summary with the following equation?
=IF([CFO Install]@row = "yes, me only", 1, IF([CFO Install]@row = "Yes, my spouse and I", 2, IF([CFO Install]@row = "Unable to attend", 0))) I keep getting #unparseable. I tried COUNTIF(s), SUMIF(s) Right now I have been creating a separate column in my sheet with the formula to get the sum. I would like to clean up my…
-
Counting date since last event
I want to count the days since the most recent event that was checked in a certain column. is this possible? Ex we have a row entered on 2/11/22 and delay is checked. I want the return to be 0 days since last delay. but then is we had a delay tomorrow it would reset back to zero again. this is for a dashboard as well.
-
COUNTIFS with date ranges
Hi, I have tried and have not been successful. What is the formula for COUNTIFS (a certain status) with the date ranges of Monday to Friday of that workweek? I need to count: 1 Test Status = 100% or 50% Within the dates of Mon 2/8/22 through Fri 2/11/22
-
Collect Join Help
I have two sheets. Sheet 1 is where requests are tracked. The user enters the date, Part Number, and Quantity they need. Sheet 2 is where the deliveries are posted. It contains the date of the delivery, Part Number, Quantity, and location for the parts. Back on Sheet 1, I have a column that I want to pull in the date of…
-
Change Dropdown Option in Cell Depedning on Date
Hi all, I have a column titled "Interview Date" where the date of an interview is inputted. I also have a column titled "Status" with two options - Open and Closed. I am trying to make a formula that will set the status column to "Closed" if the interview date is in the past. I am trying the following but cant get it to…
-
Setting up Bill Rates in Grid View?
I'm trying to set up bill rates by job title in Grid View, but finding the help documentation lacking in SmartSheets. Is this possible or are bill rate matrices only available in Gantt View? Basically, when I select a job title for the work to be performed (Project Manager, Project Engineer, Superintendent, etc.), I want a…