-
Dropdown Link is not working for me.
I am testing on this dropdown link but it is not working for me. 😣 I created both the source and destination sheet. Source sheet: text number or dropdown list column Destination sheet: dropdown list column After linking the dropdown list from destination sheet to the source sheet, the data is not showing in my destination…
-
Automation to add links in a column in origin sheet from destination sheet.
Hi, I set up an automation to copy a row from someone's intake sheet when they assigned it to my team into my intake sheet. We did this so we didn't miss any of the metadata they are capturing. Can I set up an automation that copies a column that has "DAM Link(s)" from my intake sheet back into the original intake sheet…
-
Phantom Smartsheet link
In RM I thought I might be able to connect to one of my project plans, so I followed the link to connect to Smartsheet, but I didn't have the right access so I returned to RM. But now I have a link to Smartsheet that is blocking my resource from being able to enter time in the project. I've looked in the project setting to…
-
Feedback Needed on Status Rollup Solution
Hi all, I have a bunch of underlying sheets that have the exact same setup due to a template and it has a status field with a drop-down of about half a dozen different options that go sequential order from not started to complete and verified as complete from leadership. We also have hierarchy so there is level 0, 1 and 2…
-
Save as New Issue
Hello, I'm encountering an issue when attempting to copy certain Smartsheet sheets. When I try to "Save As New," the process consistently times out, indicated by a spinning cogwheel. On occasion, I also receive an error message stating that Smartsheet is unavailable. This problem is not affecting all of my sheets, only a…
-
I occasionally get #ERROR results from formulas that are only fixed by a page refresh
Occasionally I have been getting #ERROR or other error messages as a formula result in cells that previously return a valid result, and nothing related to that cell or the cells that are referenced changed. The only thing that finally fixes this is to do a hard page refresh. The attached images show this, and the only…
-
Folder-level permissions
When will Folder-level permissions be coming out without the use of Collections? This was something discussed at ENGAGE 2023 if I recall correctly.
-
How to automate data involving dates and sum totals
I have been researching this topic for some time now and have been having trouble finding an answer - hoping the Smartsheet hivemind can help! OBJECTIVE: To obtain a sum total of data submitted via a Smartsheet form, based on submission date. CONTEXT: I work for a transportation company, and we use a Smartsheet form to…
-
Automation template not working
I am trying to use the automation template in a work plan sheet, where when I change the project status column to "completed" the "% completed" changes to 100% on the row. I have even tried to reverse it, and say when % completed = 100% change project status to Completed. This seems like a very simple ask, and is a baked…
-
Keeping Separators in Numbers When Joining / Concatenating
I have had quite a few use cases where I needed to use a formula to calculate an amount or amounts then join that amount into a text string, but when you do that, you lose your separators. If you want dollars, you also end up with no cents or single digit cents which can look a little wonky. The below formulas can…