-
Using IF AND & OR in the same function
I've seen a couple questions involving AND and ORs separately but nothing involving them together with IF. I'm trying to get a checkbox to automatically check if the following criteria match: Self Survey Column is green Workshop Attended Column is checked off Evaluations Column is either "completed" or 5 or above. The…
-
Date Column Not Working
When I enter dates into the column titled "Start Date" or "End Date", the data disappears from the cell.
-
Expandable/Collapsible Columns with buttons (not hiding)?
Is there any capability in Smartsheets similar to this excel screenshot where columns are able to be expanded and collapsed in a grouping using a button? The scenario at hand is supplier contact information being tacked on in several columns at the end of a sheet and it isn't information used on a regular basis but needs…
-
Using most recently added row to populate dashboard
Hi - I'm building a dashboard for project reporting, and need the most recently updated row from my data sheet to be used to populate the Metric Widgets. The data needs to come from a sheet rather than a report as I want to display the data split out into areas, not all in one place. I've done a lot of reading, and so far…
-
Free User - Switch which sheets are editable
Hi folks, New user here, and loving Smartsheet for the most part. My free trial just ended and I had a bunch of sheets created. I knew I would only have access to two (editable) once the trial ended. Does anyone know if you can switch which sheets are editable? I accidentally made one editable when I shouldn't have, and…
-
What Formula to use to Count the number of Unique Dropdown Phrase Utilized
I'm new to Smartsheets and I've been tasked with going over the SWOT data. They are asking me to go over each category of SWOT with the unique data point they captured and tallying how many times that data point is utilized. The Data Point Column is a dropdown list. For example, I am having a hard time counting how many…
-
#Invalid Ref
I'm trying to reference another sheet and get a count of items that meet multiple criteria. My formula syntax is =COUNTIFS({173000 High School UUU Model Review Items Range 1}, "3-Critical", {Phase}, "CD") Do I need the function HAS? When I've tried inserting HAS, I get UNPARSEABLE. With the syntax I have now, I get…
-
COUNTIFS Formula to calculate the number of values in a column with multiple values and parent rows
Hello, I'm trying to help a colleague set up a metrics sheet that can help them report on the number of skills they have within their department. There's a sheet of all the people in the department, which has a record of the person, their skills and what they are booked to work on. • Each of the people records are assigned…
-
Flag duplicate titles but not if the title is blank
Hiya, I am trying to write a formula that flags entries if the content of the title column is repeated, but I need it to ignore entries that have a blank title. My current one is: =IF(COUNTIFS([Conference Title]:[Conference Title], [Conference Title]@row > 1, [Conference Title]:[Conference Title], [Conference Title]@row) =…
-
Customizable Permissions
Often times I find that I need to give further permissions to users, but don't want to give them unfettered access to sheets. Often times my Project Managers need to add an additional item to a drop-down menu, add an additional column to track a specific need, reorder columns to fit their needs, or adjust lanes in card…
