-
Reference Predecessor Cell / INDIRECT Function
I'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's the literal task before. My problem is that I'd like to adjust the formula so that it references a predecessor task (as…
-
What new features do you want to see in Forms?
Hey! We run a form-building service at FormCrafts (https://formcrafts.com/) and have been considering building a native integration for Smartsheet. I'd love to get some feedback and suggestions on what people are looking for that's missing in Smartsheet forms. Some ideas we have so far: Being able to add custom text,…
-
Dashboard chart for daily submissions (via form) over time
I have a seven week event. I have a form set up for submissions about the event. How do I set up the metric sheet and which formulas to count submissions each day/ week to appear on the chart to show on the dashboard.
-
Linking between different sheets.
Hi Everyone, I have a roll up sheet in which we have linked data from individual project sheets. Some data from project 1 will be row 1 in roll up sheet, project 2 will be row 2 and so on. One of my team members filtered the data in roll up sheet and when the filter was removed, all the data in roll up has disappeared (but…
-
How to calcualate time difference
Hi Team, How to calculate time difference 10:00:30 AM Start Time - 11:12:00 AM Regards,
-
Getting latest data onto a Dashboard from a sheet
I have a "project risk log" in a smartsheet where every risk is scored from 1-5. I have a separate "summary" smartsheet which has formulas in to count the number of "open" risks in that log for each score from 1-5, ie there is a column in here for score 1 where all of the open risks in the log with a score of 1 are…
-
How to Fix: Value of Parent Row (days) Not Showing the Sum of the Childrens' Rows (days)
We may have run into a bug with a value on a parent row. The duration of days should be 15 days because the sum of the childrens' rows is 15 (5 tasks, 3 days each), but the parent row displays 25 days. Where could this be pulling from? Can anyone provide some direction? See Row 18 in the attached screenshot. Thanks! Des
-
Assign Workflow issue
I think I've been looking at this for too long and I need help! I received this message "We had additional conditions set up that didn't show disabled, but wouldn't assign on this workflow so we changed them to be OR and apparently it still isn't assigning but isn't showing as broken either" In the attached picture, is…
-
Sheets and Dynamic Views
There are a few existing Sheets and Dynamic Views that were created and still owned by previous employees. Because they no longer have licenses, those sheets are broken/unable to view but still appear in our sheets. Is there any way we can delete these?
-
Pass URL parameters from web ad campaign into Form hidden values
I am running an advertising campaign to get registrations on my Form. When the users click on the advertisement (either ad A or ad B) , they go to a landing page with a URL ending in -----.com/?campaign=launch&utm_source=ad_a , and the form is on that landing page. Parameters are key-value pairs that can appear inside URL…