-
Capturing multiple statuses, reminders for recurring tasks, form
Hello SmartSheet community, perhaps someone can give me ideas on how best to set up the following: I have 30 customers and 30 different reps (one for each customer) who need to provide a status on that customer on a regular basis, at least once every two weeks. The requirements: * Use a simple form to collect the data,…
-
Calculating a percent
Hello, I am struggling to calculate the % complete based upon Target Savings / Realized Savings. I am trying to track the % complete of task based upon how much of our target savings we have realized. Any suggestions are appreciated. Thank so much, Katye
-
Seeking correct formula for "If greater than, but less than" statement.
If cell A is > 30, but < 61, then cell B is "31 - 60"
-
COUNTIF CHILD AND UNRESOLVED
I have a sheet where we are tracking comments from various agencies. Each agency lists their comments as children under a parent row of the agency name. A separate checkbox column indicates whether the comment is resolved. I am trying to create a formula to calculate the number of unresolved comments per agency in each…
-
Formula for a group selection
I want to count the number of items when their description contains a certain word. Count if Description contains the word "grey". There would be multiple descriptions with the word GREY in the column. Ex. Dark Grey, Grey Mist, Green Grey, Blue Grey. I want a total for all items that are GREY. Is this possible? Other…
-
Reference the value of an active cell?
Is there a way to reference the value of an 'active cell value' in a formula or have a moving reference? The current example code and screenshot specifically call out the desired outcome by referencing each cell in a range. Example: Project1 will start in 2018, which is reflected on sheet 2. formula in column 2 row 2 on…
-
BUG?! - Inconsistent Date Format (US/UK)
I have a regular gantt sheet with start date / end date, which shows up in UK format on the sheet as per my personal settings. However, when I link to that cell from a metadata sheet that I am using for dashboards the date shows up in US format! I have another date format column which is for baseline start and baseline end…
-
NETDAYS failure
I cannot figure out why this formula doesn't work for me. I've tried a date instead of TODAY(), same results. Any help appreciated. Both columns are formatted for dates.
-
SUMIF with two Ranges.??
I want to create a cross-sheet formula and have two conditions for the formula to go through to result in a value. If the value in column1 is 1 and column2 is VendorX then sum all values in column3 corresponding to the conditions. I am not sure if the SUMIF will work for this.
-
Using SUMIF with FIND criteria
Hi I've searched the community and can't seem to find an answer for this one. I have a column with project roles and the hours for each role required for individual tasks. I would like to summarize the total hours for each role Currently I am creating hidden columns for each role and to determine the role hours for each…