-
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…
-
Finding sheet owner
I have a licensed user that has left the company. Who I transfer the sheet ownership will be determined by what the sheet contains. I can see this user has ownership of 1 sheet and I can't easily locate the sheet. Is there a way to determine who has ownership of the sheets in an account? Thanks in advance.
-
How can I convert text names to existing contacts in my account?
I manually imported an Excel file into Smartsheet that has hundreds of names as text (no e-mail addresses) which I'd like to use to pull existing contacts in my account. The first and last names match to what's in my account. I've changed the column on my sheet to 'Contacts' thinking I'd be able to leverage contacts in my…
-
How do I create a report that sums totals from my sheet?
Hi, I need to create a report that sums up the totals of each quarter on a report. How do I do this? I would normally use a pivot table in Excel for this, but I'm not sure how to recreate that same functionality in Smartsheet.
-
Problem to move infos from one sheet to an another
I have a problem with my Smartsheet sheets. I made a mistake and instead of copying datas from one sheet to an another, i have transferred datas from one to the other sheets. After this manipulation, I deleted a lot of info in the new sheet because these infos were not useful. Today I want to come to the oldst version of…
