-
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…
-
Referencing Multi-Select Dropdown in a Formula to Get Elements On One Line
Hey everyone, By default, if you a cell in a multi-select dropdown column with more than one option selected and then copy/paste that cell or reference it in a formula, each element is pasted on a separate line, like this: Is it possible to get all the elements on one line with commas, like this? Thanks!
-
How to create a conditional formula with date specifications?
How do I create a formula that counts the number of rows containing [STATUS] “Green” and have [DATE] = Today and [DATE] = Last Seven Days from Today. I do not want to capture rows that are older than seven days from today.
-
Marking Oldest 5 Projects
Hello! I have been working with some data and I want to eventually be able to pull a report of my "past due" projects and show the oldest 5 projects. To do this, I have created a helper column in my source sheet that using the formula: =IF(Date@row < SMALL(Date:Date, 6), 1, 0) in order to flag the 5 oldest dates in my due…