-
What does the LOCK do in the summary sheet?
I have a formula in the field, I locked it but I can still edit the field.
-
trying to compile "other" comments from a survey
Hi! I am trying to compile survey data into a single page. The same survey will be used over and over and the data will keep adding to the data sheet. I have a few multi-select dropdown columns, which each have an "other" category that then opens up the "other" field in the survey if selected. Often, this is not used. I am…
-
Is it possible to get a count in Sheet Summary with the following equation?
=IF([CFO Install]@row = "yes, me only", 1, IF([CFO Install]@row = "Yes, my spouse and I", 2, IF([CFO Install]@row = "Unable to attend", 0))) I keep getting #unparseable. I tried COUNTIF(s), SUMIF(s) Right now I have been creating a separate column in my sheet with the formula to get the sum. I would like to clean up my…
-
Vertical Table header
Hallo SmartSheet Comunity, I miss the possibility to rotate vertically the Table headers. This should be an essential SmartSheet Feature.
-
Sheet crashing for only one user
Hi All, One of our sheets that is used by our sales teams is crashing for one of our sales representatives. He has tried disabling his chrome extension but still no luck. Has this happened with anyone and what are some troubleshooting tips?
-
Character Limit - Need More Characters
Is there a way to set a particular field to accept more than 4000 characters? We use SS for managing projects and the "Notes" field we have established is where we run into issues. On occasion, we need more than 4000 characters.
-
Vlookup w/ Checkboxes
I'm trying to link two sheets via a Vlookup equation. I want the formula to search the indicated sheet for an unchecked box and return whatever column I indicate. I can make my equation work if I substitute numbers instead of checkboxes but I cannot make it work if I look for a check/unchecked box. What am I missing?
-
Setting Formula using RYG
Hi! I'm trying to set up a formula using the Red, Yellow, Green symbols but I'm having difficulty doing so with how we use it. So basically, we have multiple columns we use to grade our employees in a QA setting so example Red=No, Yellow=Somewhat, Green=Yes. I am not even sure if this is possible. Any input advice how to…
-
Visual grouping of data - input requested
Hi, looking for suggestions/tools on a way to show data visually grouped ideally without using parent/child relationships. e.g. if 5 initiatives were all tied to one larger objective, I'd like to only reflect the objective once (vs. in each row), with the 5 initiatives shown to the right. I know the calendar app offers…
-
workflow automation - rows aren't moving?
Hello, I created a workflow to move rows once a column status is changed to "complete" within any row. But the workflow didn't trigger, even when I manually changed the status to something else and back again, saved, refreshed, tried again. It finally worked when I moved the row to a different spot in the sheet (shifted up…
