-
Status Rollup to Parent
I've seen some very similar solutions to my problem, but not quite what I am looking for. My Smartsheet plan has a status column and is using dependencies. My choices in the status column are (Not Started, In Progress, At Risk, and Complete). I would like to create a formula that automatically rolls up the parent of each…
-
Memorializing cell content
I have a column that calculates a date based on 'Column XYZ - 127'. This works perfectly. However, if 'Column XYZ' changes then my destination column will also change (obviously). But I want to preserve what the date WAS before it got changed. So I thought to insert a 'Helper' column and copy the date from destination to…
-
Need help with counting criteria within a date range
Hi - I am looking to count cells that are "in progress" within a specific month, for example, August. I use this formula but the count doesn't come up correctly. Can you help? Thank you! =COUNTIFS({Turnaround Plan Range 1}, "In Progress", {Turnaround Plan Range 2}, <=DATE(22, 8, 1) >= DATE(22, 8, 31))
-
Transferring largest value of children's row
I am trying to report the document review status. As you can see in the picture, I'd like to report the latest version of the comment sheet of every document. In the picture, for each topic (there are two topics: Gardening and Cooking) there will be many documents. In this example, Gardening has 3 documents : Apple,…
-
Help with if and and if and or statements
Hello I am trying to work out an if or and statement! I want to only return DVCEE when either the first or the last part are correct. I have been dwelling on this for days! Please send help! =IF(AND([ABC approval]@row = "ABC Approved", [Type]@row <> "SA", [Type]@row <> "ST", [Type]@row <> "SO")), (IF(AND([Type]@row <>…
-
IF Formula using multiple cell values + date
Hello, I have a formula for employee referral bonuses that calculates the date the bonus payout is due based on the start date if the hiring source is employee referral. =IF([Hiring Source]@row = "Employee Referral", [Start Date]@row + 30) This works fine for 30 and 60 days because it applies to all employees; however, for…
-
Formula Question
I'm developing an inventory smartsheet that keeps clothing inventory in one sheet and then a form that allows an employee to request clothing for team members. I am working if I can create a formula to deduct the quantity of each clothing apparel once it is requested. There is no approval process needed. Smartsheet 1: Kit…
-
How to count number of entries that fall between two dates
Hi! I have a sheet that has a date column to enter the initial date of contact. I want to count how many of those entries fall between 2 dates (by month) i.e. I want to know how many of the entries have a date between 1/1/22 and 1/31/22. This is my formula but it's not calculating correctly as I know I have 2 entries with…
-
Formula for Multiple Checkboxes
I have a sheet with submission form, in the form there are two different sections. One where they have to pick a checkbox option from a list of 4 and the other is one out of 8. I set it up this way to be able to provide details for each selection. I'm trying to find a formula in the sheet so I can hide all the checkboxes…
-
Capacity vs Demand Utilisation RAG Column
Hello, I'm looking to create a capacity vs demand utilisation RAG Column where it will appear with Red, Amber, Green for the following rules: Green: Total Q1 Capacity = Q1 Total Demand Yellow: Total Q1 Capacity > Q1 Total Demand Red: Q1Total Capacity < Q1 Total Demand Kind Regards, Luke