-
Open Sheet in Gantt View
My sheet is opening in grid view. I can change it to Gantt once I am in the sheet but how do I change the settings so that it just automatically opens in Gantt view?
-
Email User Completed Form
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
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…
