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 …
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…
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 Additio…
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 …
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…
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…
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?
Hello, I am trying to create an alert that would notify users once an agreement has been signed. I have watched some Smartsheet videos but I'm still a bit confused on how to create one. Why might the …
Does anyone know if there is a way to add a formula for a report? What I want to do is sum the values of a column for all rows returned for a report and to add some sort of highlight when the sum exce…
Hello! I’ve been using Smartsheets for a while now, but am new to building them. I am having trouble working with formulas to identify current status of my tasks. I’ve searched the community and have …