-
Issues with alerts - not sending 'right away'
I created alerts to be sent 'right away'. However, we are receiving them via email several hours later - sometimes 12 hours later. I confirmed that I checked 'email' in my notification settings. Can you please help me figure out why there is a delay?
-
Calculate Reverse Date Format
Hi dears if someone can help with this format I have 3 cells: 1-ESTIMATED REQUIRED DELIVERY DATE: include the estimated date of delivery 2-PROCUREMENT TIMELINE: autogenerated including the number of working days 3-PR ESTIMATED SUBMISSION DATE: I need to create a formula that can automatically calculate the reverse date of…
-
Percent Formatting applied, but entry of 100 is shown as 10,000%
I have the entire column formatted as a percent, but when I enter 100, it shows as 10,000%, or when I enter 1 it shows 100%. Would like for the number entered to show that percent.
-
SUM of Only Parents in Budget Sheet
Hello! I've created a budget sheet with sub items. I figured out how to SUM the Children under a Parent line but what is the simplest way to SUM only the Parents for a Total that does not include both Children and Parents? Thank yo!
-
Is it possible to stop a flow pulling in a duplicate line item
Hi all, Hope you are all well! With the help of this community i have created a form that will automatically identify how a line item and how long it is before being cancelled. This form will then send emails to Project Managers once we are 5 days away from cancellation and then a day away. Because of this, we are going to…
-
Effort Vs Duration
Hi I am new to smartsheet and wondered if you could help. I would like to create a project plan which shows the effort required vs the duration. for example: a task may take 2 days to complete however they can complete this anytime within a 5 week time spell - how would I show this on the plan so that the resource…
-
Is there a way to pre-populate past survey responses by user?
I have a feedback survey(form) that users fill out a few times a week and I was wondering if there is a way to have their responses pre-load from the last time they answered. For example, say they fill out the survey three times a week and nothing has changed over the course of the week and they want to submit the same…
-
Aggregate Status Circles w/ Formula
Hi, I have these multiple statuses across 4 projects (each project is one of the rows) within 1 program and I want to be able to incorporate a formula where I can summarize all of these to a single row with the same columns in a separate sheet to present at the program level. Formula to say: If there's at least 1 yellow…
-
COMPLEX INDEX/MATCH arguments issue: Project Updates Tasklist
@Paul Newcome @Paul Newcome I need your expertise My manager has tasked me with referencing data from a hierarchy of rows, for multiple columns, but wanting the Parent Row to be updated from the inputs of the data in the CHILDREN rows, which he then is asking for the most recent update of that selected customer. I am…
-
Setting up a Project Portfolio- next steps
Hi all, I am new to the community and pretty new to Smart Sheets. I have been tasked with creating a project portfolio with a hopper of projects ready to start when resources become available. I have built the project portfolio linked to the individual projects but it is static at the moment. To get the next phase I have…
