-
Storing documents in a folder, in a Workspace
Looking for best way to share and store documents (Word, Excel, Visio, PDF, etc) inside of a workspace. .. Ultimately, would like to have a tree of folders that will serve as a Data Room for a particular project. Has anyone tackled this previously? Any way to make it work effectively without having to attach to rows and…
-
Moving Rows to another sheet - won't work
We have projects with a number of parent/child relationships. Once a project is completed it needs to be archived to another sheet however, Smartsheet doesn't seem to allow me to move them. Typically there is approximately 100 rows per project which I presume is part of the problem. I have tried selecting less rows and…
-
Index/Match (any limitations?)
I'm using index/match to reference account parameters on a master sheet from other sheets (sheet A, sheet B, sheet C, etc.). How well will this scale up? Can you use index/match to pull values from the master sheet to an infinite number of sheets or is there a limit to the number of times you can query the master sheet…
-
IFERROR
how can I add IFERROR to this formula =WORKDAY([Start Date]140, 15) I tried =IFERROR(WORKDAY([Start Date]140, 15, "")) and it didnt work
-
Forms - Customization
I have created a form from a Smartsheet and when I preview it, it appears to be correct. I have left out columns that I do not need to have a user enter. These are a checkbox column and also three columns at the end which I use for formulas/metrics. Is there a way to hide these in the form?
-
Dark Mode feature need
How can we get a dark mode feature into the pipeline? It's very common these days for reports and forms to throttle between regular and dark mode. Hope this can be done easily to stay up to date.
-
Metric Widget Column Header
I am trying to grab data from my dashboard metrics sheet in such a way that data is associated with the selected column header, as opposed to the actual column header. I am trying to use the Metric Widget like how I use the Chart Widget, but am getting results like in the screenshot, attached, where the heading I am…
-
Sharing with non Google mails
Hi, Is it possible to Share sheets with non Google accounts? If so, which password do they use to enter? Thanks
-
Completion Status Bar with the Task Bar
This is a fairly straight forward question and I think I might know the answer, BUT here it goes. The completion status bar within the task bar is typically driven by the % Complete column. It appears that column (for the bar to work correctly) has to be manually entered. If I use a formula, it will give me a % but will…
-
Product Suggestion - Admin Issues
This popped into my head as we have one of our licensed users who just refuses to share anything with any of us. What happens if they create a lot of important sheets that contain data and part ways with the company, how do we access this? The Super Admin should automatically have the ability to have access or a backup to…