-
Link Reference Sheet Dropdown
Is it possible to reference a list on a separate sheet for the user to select as they input data into rows?For example; activity type, client name? I have created a time sheet and would like users to reference the data in another sheet. Thank you, Rachel
-
How to build an IF formula based on a date field
Hello, I am looking for help in building an IF formula that will return a number value, based on how far in the past a date is (using a date field). Where a date field is populated and depending on the date, a number will be chosen : 1 = a date that falls in the last 2 months from today 2 = a date that falls between 2 and…
-
column date depending on symbol column
Hey, I couldnt find an answer to my question here, therefore I hope you can help I have columns: 1) star symbols 2) last date ( I enter manually) I want to calculate "next date" f.e. if star is "1" or "2" = last date + 90 days if star is "3" or "4" = last date + 60 days if star is "5" = last date + 30 days if star is "6" =…
-
How do I fix a VLOOKUP problem?
Hi there I'm using a form to capture COVID RA Test results, scheduled for different departments on different days. The schedule uses a VLOOKUP to populate the 'test result' column from the form results and allows us to report on anyone who was scheduled to submit a test by a certain time but hasn't (report if blank &…
-
Formula to return boolean looking at multiple date columns
Hi I need a formula that will look at three date columns and if any of them are date that isn't in the last 5 days, I want a boolean '1' returned. This is what I've used: =IF([Project Health RAG Last Updated]@row <TODAY(-5) OR(IF([Current Position Last Updated]@row <TODAY(-5), OR(IF([Next Actions Last Updated]@row…
-
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 <>…
