-
Column not found error in OOTB backlog planer and report
Hi, I have deployed an Agile project - predefined set of smartsheets: https://app.smartsheet.com/b/publish?EQBCT=dc9947a9e8f34d1ca6ad207b18505e59 Dashboard - Backlog and Sprints Report - In Progress Tasks Sheet - Backlog & Sprint Planner However, when there's an error in the columns available in the report showing that I'm…
-
Formula IF and NOT Validation
I am trying to check a flag when two conditions are met: End Date is past Today's Date Status is NOT "Complete" I am sturggling with this for some reason and cant see where I missed something: =IF((TODAY() > End@row, NOT(Status@row = "Complete", 1,0))) Any pointers would be helpful.
-
Reports user-friendliness
Hello, A little bit of context: I have a central Sheet displaying data and gathering inputs to & from multiple stakeholders via individual reports. This sheet holds a number of workflows, is fed by several datameshes, etc. In theory I don't want users to be able to see data from other users. To do this here is the option I…
-
Need suggestions on this scenario
I'm thinking of switching our very manual email + Excel/Google Docs, etc. into Smartsheet. I'm aware of the cell/row/reference limitations per sheet, so I'm thinking of dividing the work in different sheets as follows. Below is the process workflow I'm thinking of, but I did have some questions if it's even possible (in…
-
Add External Placeholder to Smart Sheet Form
Hi there, I'm wanting to embed a simple SmartSheet Form in another program either via link or embed. The other system has placeholder tags which I would like to use. I can't figure out how to make it work so that the placeholders get pulled through to the form. Here's a link to the help info from the other system. Is there…
-
Hyperlink Properties
Hi Can Smartsheet be used to link to an existing file or document on the web (Not to another Smartsheet document)? Grateful for any assistance.
-
Viewing real time collaborators sheet updates
I have a Smartsheet that has be shared and is in use with others in our business. My problem is I am unable to see any input to the sheet that has ben done. What do I need to do to see this. Thanks
-
Determining SmartSheet access method email+password vs Microsoft (Azure AD)
Is there a way to show what method users are using to log in? I want to ensure all our internal users are using Microsoft (Azure AD) as the login method rather than email+password and it would be useful to know who is using which method. If I shut down email and password access I believe that will affect external users, is…
-
Wrap text for header possible?
Hi there, is it possible to wrap a text in a smartsheet header? Thank you & best regards, Manuel
-
Auto-Workflow
Hi , I have an Automation Workflow something like this if request glow green, then copy row to another sheet ,lock row, change some cell value (requestername to xx) that all works fine.. then i set some reference to Ready column...Now i have an another automation if Ready glow "star" then unlock rows ... this automation is…