-
Match Numbers from one sheet to another
Hi I'm trying to make a inventory with a reference from a another smartsheet sheet, but since im kinda new into Smartsheet I dont know which formula I need to use. Its a hole Row from one sheet and then tell if it exist or not in the one that im working on.
-
Project Tracking that includes working day tasks and calendar day tasks
Hi All, I am attempting to manage a project that includes tracking tasks that follow our company's cultivation process in addition to production tasks. As most of us know, plants don't take the weekend off... Has anyone found a good workaround in project settings to account for this kind of project tracking variability? We…
-
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…
