-
SUMIFS and Referencing Another Sheet (Financials) = INCORRECT ARGUMENT SET
Hello all, I'm trying to compile some financial totals for various departments into a Metrics sheet for Dashboard reporting and something is not going right. I can get the total for all departments from the referenced sheet with =SUMIF({Total}, but when I add the criteria for each department I get # INCORRECT ARGUMENT SET.…
-
Auto-status, 'Up Next' criteria overlap
Hello! I am working on a sheet with Start/Finish dates and need to populate status' into the following 4 categories: not started, in progress, complete, up next For not started/in progress/complete i have the following formula working: =IF(AND([Start Date]@row < TODAY(), [Finish Date]@row < TODAY()), "Complete", IF([Start…
-
COUNTIFS w/ new multi select dropdown
Hey all, I'm looking for a way to use the COUNTIFS function on a column that is Dropdown (Multi-Select). I've seen a few tips about using "Find" but when referencing another column on a different sheet, keep returning an error. For this example, I'm trying to count department names. Thanks in advance!
-
CountIF with Criteria including date range
Hello, I'm currently trying to create a countifs formula to count the number of "issue type"(column) "story" where it meets certain criteria including falling within the next 30 days. My base formula works here: =COUNTIFS([Issue Type]:[Issue Type], "Story", Labels:Labels, "Groomed", Status:Status, "To Do") However, when I…
-
Automation Email Notification
Can be possible if the automation email from smartsheet comes with a Customize sender information instead of the information of owner of the sheet? We created a ticket system and the automation email comes with the owners name and when the people reply to the automation email send email to creator of the sheet. We want to…
-
Set a row to 'not applicable'
Hi. My project contains 3 sheets to represent network areas and includes the site locations within the networks. The project tasks are the same and include deployment stage gates and user adoption stage gates. We would like to use the same set of stage gates across all of the network areas for consistency and reporting,…
-
What's an effective way I can plan my resource's hours for the next recurring 12 weeks?
Right now, my management asks PM's to predict how many hours their resources will be spending on a given task (tasks = rows) per week (1 week period = 1 column)? What's a possible more efficient way to do this? At the moment, we have to manually input new columns after the initial 12 week period is up. It's a time…
-
Reporting on who and how many times an individual has attended events
Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows: We manage multiple events in Smartsheet. We use forms for sign ups so all the data about who is attending our events is in multiple sheets. Using email…
-
Help with Cross Sheet JOIN(COLLECT) formula
I've built a formula to complete a JOIN(COLLECT). If I put the formula on the same sheet as my column references it works just fine, however when I move this to a separate sheet and update the column references to the other sheet I get the error #UNPARSEABLE. From what I can tell I haven't removed any of the formula…
-
Calculating a minimum payment figure using a formula or function
Hello, I'm hoping someone may be able to help me with something that probably seems quite obvious or basic however, my knowledge on formulas or functions within Smartsheet is not advanced, so I apologise in advance! I'm trying to get my finances in order and thought I'd use Smartsheet to plan this. I've done a screen shot…