-
How can I enter data in a field that has a column formula?
I have a Contact list as a column type on sheet A and it is attached to my feeder sheet B. Sheet A also has a form attached to it and when a list option is selected, the contact list is populated on the sheet. However, if the list option is not selected, then the contact list does not populate. I need to be able to fill in…
-
How can I use index match + either another index match or an IF statement to pull Data from multiple
How can I use index match + either another index match or an IF statement to pull Data from multiple sheets? In my case I have 3 sheets: Sheet 1 - Current Project List - consists information that track active projects. (each Project has a unique project code) Sheet 2- Closed Project List - consists of previous years…
-
Formula help please! What formula to mark the parent row "Complete" with an "Not Applicable" task?
In my status column I am using this formula auto update my my parent row: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(), "Not Started") > 0, "In…
-
Column Formula to populate a Helper Column
EDIT: I just realized this is listed in the Add Ons and Integrations section rather than elsewhere, but I cannot move it. I have created separate helper columns to return the value in [Plan Start Helper] for any of the matching [Opp #] where [Plan] contains the word "Plan" (I have other helper columns that need to search…
-
How if a box is checked it any point in the process it will mark it checked for that section
I have sheet that has many items on one that all have a similar process. If one is marked sold at any point (any child step) it will check all the sold for that particualr parent and children. This will stop the notification for that particular item. I do not want it to check the boxes for the whole column because it will…
-
Formula to count days past a certain date without weekends
Hi! I have a sheet where one column has a submission/end date ("END DATE: CA Exam 4 Part 2") and another column is a "due by" date ("E4 Window Closes"). I have a column that I keep hidden which has that "due by" date ("E4 window closes") to help in the formula I have running: =IF(AND(ISDATE([E4 window closes]@row), [E4…
-
Column Formula Help - Helper Checkbox for Shift Entries
Hello Community, I am looking for some help with a helper column checkbox formula needed to support reporting of data to a dashboard and downstream formulas. I have four shifts (A,B,C,D) entering data points into a sheet, with the potential for multiple line entries occurring per shift per day worked (see example below). I…
-
Count if Between a date range
Morning Smartsheet community, Hope you all had a great festive period. I'm struggling with a formula that would make my reports a whole lot easier….. I have a helper column that I want to return a value@row could be anything but for ease say "1", If the date in the [Form Date]@row is between the dates set in [PP Dates]1…
-
Tricky formula!
I receive a report each month that gives me values at the end of each month for a particular group of individuals. See below for the report. The report is delayed so I'll get new numbers for November in December, etc. I need to first report on AUA #'s for that month and then YTD. For example, I'm running numbers for March…
-
Best Formula to use for Validation between 2 Columns in 2 Sheets
Good Day, Looking for some ideas/suggestions for a formula to use to verify values placed in a column in a sheet. In my scenario, I have Sheet 1 and Sheet 2. Within this 2 sheets are 2 columns that need to match. Sheet 1 - Column: 'Product Category' is a manually entered field. This column/field needs to match or flag when…
