-
Permission changes - Create & manage manual alerts for other people
Alerts, reminders, and requests * Create and manage manual reminders for other people * Create and manage manual update requests * Create and manage automated alerts and reminders Does this mean that any time someone wants to be alerted about a change, etc, that only a licensed user can create them? Our Company has…
-
Open To Today's Date for Viewer and Editors
The "Open To Today's Date" feature works for the sheet owner/admin, but if the user just has "editing" or "viewing" rights, they are forced to scroll on the x-axis to get to today's date. Is there a way to make the feature also work for all users?
-
Help with Formula!
Hello, I'm pretty new to smartsheet but slowly working out how to create some functioning formulas! I wonder if anybody might be able to help me with the latest one please? I have multiple columns containing different data types (some are tick boxes, others are dates and some will say 'N/A' - I am trying to write a formula…
-
Prioritize/sort rows (possible feature request)
It is possible to drag 'n drop rows to change their order, but if you order by some column this "index order" is lost. I need some way to prioritize rows, with the most important at the top. I can do this by adding a column of type number, and manually enter the index for each row, but this is rather cumbersome. What I…
-
Automatic Jira to Smartsheet ONLY
I'm trying to setup an automatic, one directional Jira to Smartsheet sync. The options are either bi-directional automatic, or manual one direction. The manual only updates if I click through multiple screens to find the workflow "Run" button. The Automatic scares me because I don't want Jira getting corrupted since lots…
-
RYG Symbols from 3 Columns
I am trying to return a RYG symbol based on 3 different columns(Decision) Approved, Needs Additional Information (Denied), or Submitted. Based on these 3 columns data, if any of them say "Need Additional Information", I'd like the Symbol (Status) Column to be the Red Symbol, however if all 3 Decision Columns are "Approved"…
-
sum hours assigned to a contact on a sheet for a particular month
Example: I have a project that lasts three months on a project sheet. I am required by the client to report out how many hours of work have been completed by each person assigned to a task at the end of each month on a dashboard So for example: I need a formula that is going to Find all columns assigned to the contact…
-
creating row report & summary report from 1 sheet
I love the new summary report option but I still want to be able to create a row report from the same sheet. I have already created a summary report but I also need to add a row report to my dashboard for the same sheet. I used the summary report to create a chart on my dashboard. I tried to create a row report but the…
-
Auto Lock columns or rows through formula
I want to know if it's possible to create a conditional formula (or something like that) that as a result Lock the row or the column. When the user's filled the entire row I want to lock it from other changes, automatically.
-
Smartsheet in Commercial Real Estate
My team is working on incorporating smartsheet for our landlord and tenant rep clients, as well as our team. Any suggestions on best templates, etc to use?
