-
COUNTIFS , based on previous days - not including current day
my current formula is =countifs(field:field, (@cell > TODAY() -7),….. or (@cell> TODAY(-7)…this comes back with a total that included today. Is there a way to count the seven days prior but not count the current day in the formula?
-
Seeing #UNPARSEABLE issue when applying formulae in the summary
Wanted to calculate the Average of time difference with some conditions like Implemented column is checked for the Level 1, and the final Level2 task is completed, then calculate time from the dates in the final level2 task called 'ECO Implementation". Here is the formula I generated but I see #UNPARSEABLE error.…
-
Hyperlink Templates
We have the ability to hyperlink smartsheets within other smartsheets. It would help to be able to hyperlink templates within other smartsheets.
-
Embed a published smartsheet calendar onto dashboard
I am trying to embed a published version of a smartsheet calendar on a dashboard but I need it to stay on a certain filter once it is embedded. Is there a way to do this? When I try this - the filter has not been "sticking". And just fyi - the majority of the audience that will see this does not have a smartsheet license…
-
Adding Images in Form Body and Descriptions
Currently, I am using Google form to capture responses because of the easy creation logic using section builder and adding images to the questions. It would be great if the smartsheet form had the same capability as google form with easy creation of logical questions by adding images with the questions.
-
I need help with the RYGB Status Balls formula
Hello, I am trying to calculate health status (RYGB) for each task and milestone. Red= Not Started and past due, Yellow, In progress, but % complete is equal to or lower than 48% (.48), Green is in progress, % complete is equal to 60% or greater and blue is completed. I have read through many posts, but cannot seem to find…
-
Automate reminders for Update Requests
I would like the ability to automate reminders for pending Update Requests where the user has not yet responded. When the user submits the update request, the reminders would stop. Ideally it could be built into Automations to select pending update requests and send a reminder after X days or within X days of a due date,…
-
Impossible to fill a form - paid plans problem
Good morning, I recently changed the owner of our paid plans but, since then if someone try to fill the form, receive an error message: "Sorry, you cannot access this form because it was published as part of a free or trial account" We obviously have a currently valid paid plans "Business". What's happened? Thank in…
-
Email alert when Automation fails
Is there a way to trigger an email alert when an automation fails? I have an automation set up to move rows to another sheet that meet a certain criteria. This was working fine until the helper sheet hit a row capacity. I can resolve this, but is there a way I can trigger an email to be sent to me if any of my automations…
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
