-
How do I auto-save a sheet without opening the sheet?
I use conditional formatting. When I review the dashboard, the formatting doesn't update until I go to the sheet and save. I would like the sheet to save automatically when conditional formatting makes changes. Thank You.
-
COMPLEX INDEX/MATCH arguments issue: Project Updates Tasklist
@Paul Newcome @Paul Newcome I need your expertise My manager has tasked me with referencing data from a hierarchy of rows, for multiple columns, but wanting the Parent Row to be updated from the inputs of the data in the CHILDREN rows, which he then is asking for the most recent update of that selected customer. I am…
-
UPPER formulas
Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
-
Can I start multiple workflow in the same time and using same form?
I am tyring to make an ERP system. I created workflow to approved from the purchasing department and its department's manager with email. However, i want to add multiple items in the same time and same form to approved(in item code column). How can it possible ? I tried multi select dropdown but workflow does not work.…
-
Alerts stopped working
Late yesterday on 04/04/2019 our alerts on more than one of our sheets stopped working. I turned some on and off and tested a few different sheets, but they are all not working. I know I received an Update from Smartshets yesterday that Smartsheet was updated. So, could that be the issue? I have not changed anything on my…
-
Automation Question
Good day everyone! new to smartshets and hoping to get some help. Is there a way to have an automation that will recognize multiple values (ie: ABC = Gabby, BCD= Debbie) or do I have to create an individual automation for each value?
-
Master Roll-Up for multiple project sheets
I am reviewing the Construction and Facilities Management template set provided by Smartsheet. I only have a Team account for now. The template comes with 2 sheets for Projects. In the Master Roll-Up sheet, you can see the formulas used to pull the info from the 2 Project sheets. Question: Do I have to manually update the…
-
Why are charts appearing very pixilated and low quality?
Using latest version of Chrome, just updated it and cleared cookies/cache then restarted my computer. This has never happened before not sure what is causing it: I am zoomed in 100%, even at 50% or 150% the problem is the same.
-
Default view when a user opens a sheet
Hello! What is the default view for a unlicensed user when they open a sheet? (In regards to collapsed and expanded rows) Is it the same as the last way they viewed it, or how the last user had viewed it? Here is the specific question from my colleague: "Usually when I'm done with a set of tasks I like to collapse them…
-
Multiply cell by 2 if checkbox is checked
Hey Smartsheet users! I've read through a lot of check and IF formulas and haven't been able to find my answer so here is the situation. This is for a mileage reimbursement form. I have a column titled "Mileage" and another column titled "roundtrip" the Roundtrip column is a checkbox column. See picture for what I'm trying…
