-
Count IF And?
I am trying to determine my "deliverable count" based on if the following columns are in agreement Project Phase checkbox is checked Project Sub-Phase checkbox is checked Status is "In Progress", "Not Started", "Roadblock", or blank
-
Count If / And
I am trying to determine the sum of the "Deliverable Count". Sum will be counted if.... CountIF "Project Phase" checkbox is checked or "Project Sub-Phase" checkbox is checked AND Status is: "Not Started", "In Progress", "Roadblock" or blank Thank you for any guidance.
-
"Rank in order" questions in survey
I'm using a form to create a survey which includes 4 questions with this format: "What are the biggest barriers for ...(please rank in order of importance from 1-6)". I've considered one option: Each question would be accompanied by 6 columns to represent each of the options to be ranked. In the form, respondents would…
-
How do I get Smartsheet to update all dates in project when I change Start date?
Working on year long TI construction schedule and start date is constantly changing due to contract negotiation reasons and others. Having all dates auto update by changing start date will save a lot of time. Thanks!
-
What happened to the description option in attachments?
I have using this feature for ages, now it's disappeared from the options menu.
-
Nested At Risk Flag Formula
New to formulas! Would love a review: Flag if any of these bullets are met: 1) "Status" = Planning, In Progress, In review AND #times due date pushed is greater than 0 2) "Status" = Planning, In Progress, In review AND due date is in the past 3) "Status" = Roadblock OR Paused 4) "Health" = "Down" Here's my failed formula:…
-
MIN(CHILDREN()) Not Functioning As Expected
Hello Smartsheet Community! I am using the MIN(CHILDREN()) and MAX(CHILDREN()) formulas to determine dates that roll up to my parent row. In testing out the functionality it appears that the MIN formula is not pulling through the oldest date as I would expect it to. Some background: I am currently using 6 date columns. The…
-
Task SubTask Attachments
My team uses card view exclusively to manage tasks assigned to them. Many Tasks should be broken into subTasks that are performed by multiple team members, each adding their contribution in the form of attachments. A very basic example Member 1 is responsible for prepping data on task Member 2 is responsible for loading…
-
Automation triggered by an email
Hi, Can I send an email to a Smartsheet, whereafter the Smartsheet does this: 1, locate textstring in email. 2, compare text with row. 3, send email or textmessage to a person in a contact cell in that row??, Thanks in advance /Poul.
-
Collaborator name vs email appearing in Share list
When I share a Workspace, some collaborators appear in the share list with their name only and others with email only. In both scenarios, their Contact includes first name, last name and email AND both are free collaborators. I need them to appear/be listed by name, instead of email only. I've removed and shared again to…