-
Limiting a drop down list based on logic in forms
Hi, I'm trying to limit the number of options displayed in a form drop down to only show a subset of the child options which relate to the parent that has been selected. I would prefer not to created different form field for each option as this adds columns and leave lots of blanks in the sheet. If this possible?
-
Adding up total check boxes
Hello I am trying to find a way sum up in the comment column row 1 the number of check boxes that were checked off in each row 3+3+2+4 So on each column i have the formula =COUNTIF([7/9/21 - Friday]2:[7/9/21 - Friday]24, 1) + "...etc" This formula provides a count for column where a check box is checked off. I would nowโฆ
-
Counting time
Dear community, He use listed statuses to indicate the state of development of our planned tasks. We have a planned duration per task and the tasks are often paused to fit urgent matters or because they are blocked. I would like to be able to compare the planned duration of a task with the actual completion time, but dueโฆ
-
Changing State Based on Criteria.
Hi all, I think I have some syntax incorrect in my code and hoping for some help. Currently, I have a formula that sets the State of a task based on % Complete: "=IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 1, "Complete")))" I also have anโฆ
-
COUNTIF with Todays date changes on full sheet load
G'day I'm having an issue when using =COUNTIF with a submitted date. I'm trying to count the number of submissions to another sheet for; Today, the last 7 days, the last 30 days, and so on. The calculation seems to be working, but the number changes very quickly after the page loads. For example, shows the count as 8, thenโฆ
-
Help with Nested If Function
Hi, I want to change the Health column based on several conditions; If the due date is past due, red; if the due date is less than 5 days away and % complete is 0, if the due date is less than 5 days away and % complete is 50% or less then yellow, otherwise green. I cannot get the function to change health to green whenโฆ
-
Can I use the "IF" function to create categories in a single column?
I'm doing this formula but I only received the first two criteria.ย What I'm doing wrong =IF([Days to Target Due Date]@row > 60, "More than 60 days for Due date", IF([Days to Target Due Date]@row <= 60, "Less than 60 days for due date", (IF([Days to Target Due Date]@row <= 30, "Less than 30 days for due date", IF([Days toโฆ
-
Formula Containing Two Separate Column Results
I am attempting to create a Smartsheet Summary field that contains a formula that provides the count of the number of risks I have in the risk column of a sheet combined with a status of not closed in a subsequent status column. This is the formula I have written but it is returning a parsing error: =COUNTIF([Risk orโฆ
-
Need Help with formula: Join(Collect
I am trying to look up multiple criteria (VENDOR PO), (SAP LINE#) referenced in another sheet and return (CPSD) if it matches the criteria. current formula below I need to edit the highlighted in yellow so it looks up the vendor name and then matches the (VENDOR PO) and (SAP LINE#) to return the (CPSD) Below is where myโฆ
-
Cumulative Column Formula with Exclusion
I have a cumulative column formula created that cumulatively adds up months, if we're in May, it will add Jan-April, if we're in June, it will add Jan-May, etc. There are some metrics the customer wants to be excluded from this formula and instead, have the formula provide the last month entered. I created a checkboxโฆ