-
if/and/or formula help
I have a set of training records data. Some have required due dates, some do not. I need a formula that set s flag (for items needing attention) if: the complete date is blank the complete date is > the due date (if there is a due date) for this condition, i need it to ignore if the due date is blank When I use this…
-
Individual email messages from form submission
Hi, we have a new employee signup form. If the hiring manager adds multiple new entries, they all come over in one email. We need them to come over in separate email messages. Is there a way to achieve this? See attachment, we need these to be 3 separate emails - Thank You
-
Need suggestions for the BEST task-related template to use in Smartsheet??
There are several and I'm combing through them, but finding that none of them seem to have what I'm looking for. I manage a small marketing department and I want to be able to task out and track items that me and my staff will cover. This isn't only proposals, but other stuff too. I like the dashboards and can handle…
-
When a new line is added to a smartsheet, set a default value for a column
Once a record/line item is added to a smartsheet, I want to set the status column to Pipeline. How that work?
-
Lag between data in source and dashboard charts
This discussion was created from comments split from: Smoothing out update lag between metrics sheet and dashboard metrics widgets.
-
Default Drop Down Value
It would be nice if when a row is created any column with a dropdown list was able to have a default value in the cell until updated. This would help instead of having it just blank until someone updates it (such as a not started value until it is updated).
-
Count of Collaborators on any Sheet
We recently switched from Chrome to EDGE. Before I was able to see the # of collaborators in any Sheet, but now in EDGE the count is missing… Is there any way to restore the collaborator count?
-
Roadmap from Portfolio
Hi Community, I have setup a project portfolio with multiple project folders in the workspace. How do I create a roadmap for all projects? I thought of just presenting the project intake in Gannt format, but it lacks the project dependencies. Is there a way to present this with each project dependency? Thank you. Regards,…
-
Formula assistance - multi select column and a not blank column
Hi! In a multi-select column, I'm trying to count the number of specific criteria and another column that is not blank. Both must be met and I'm unfortunately seeing an error message. Any suggestions? Thank you! =COUNTIFS([Format Type]:[Format Type], HAS(@cell, "Live - Symposium"), [Format Type]:[Format Type], HAS(@cell,…
-
What template is best for Managing multiple projects?
Good morning, I was hoping someone could point me in the right direction. I run a small cabinet shop and we have anywhere from 3-7 projects in our pipeline at one time - I was hoping to use smartsheet to manage these and see the different phases each project is in - all in one place. Thanks in advance.
