-
Find if any string from a list of strings is present in a cell
Hi I have a sheet with a column "List of Tests" that has a list of test codes, e.g. row 1 = T101, row 2 = T102, row 3 = T103; this same sheet has another column "Selected" that has a check mark to show whether or not the test was selected. A second sheet has a column that has one or more tests listed called "Applicable…
-
Imported Contacts
I have an excel import that has names of persons. I need a contact list to generate items, dashboards, reports, etc. How can i make the imported column with names a contact list so that when it is updated upon a refresh it will not affect the contact list. or do i need to create a different contact list/column? if so, how…
-
Column Formula for only Parent Rows
We have a few sheets that use different formulas for both Parent & Children rows. Is there currently anyway reference whether a row is a parent or a child row so that we can run different formulas in the same column while using the column formula functionality? Thank you!
-
November Question of the Month - Join the conversation and receive a badge [+bonus badge!]
Hello, hello. October’s question had a very clear trend — the Community members don’t fear challenges, change, feedback, or failure, because these are great ways to learn, get creative, and grow. Love that mindset! Who's ready for a new question, and a chance to earn badges and points while getting to know your peers? Read…
-
When a date reached Trigger, not running
Hi All, I'm hoping someone may have experienced this previously & may be able to help, I have set up a 'when a date is reached trigger' that runs every 3 months for update requests for our team in Vic, I have recently recreated this to also run for one of our teams in Qld, very same automations with just a different start…
-
How to show 5 different sets of checkboxes in same column?
Hi, I'm putting together a slightly complex master sheet for Dynamic View. It needs to show something like 5 different sets of checkboxes in the same column. I'm thinking I can achieve this either by creating 5 sheets, each showing the individual checkboxes OR a single sheet with the various sets of info in individual…
-
Some dates importing incorrectly through Data Shuttle
I am uploading data onto Smartsheet through Data Shuttle from a CSV file. I have a date column and have confirmed most dates are importing correctly, however there are instances where the day and month are swapped. i.e. the date on the CSV file reads 12/04/24 (DD/MM/YY), but is added to the Smartsheet as 04/12/24. I've…
-
Error when running out of CPU memory
Not really a question but more of a heads up. I had a sheet with almost the max rows and 6 columns and 2 references. Tried to add a column formula and my CPU ran out of memory. After the browser crashed I went back to the sheet and smartsheet threw the exceeds 2.5 Million cell reference error. Im no where near 2.5 million.…
-
Formula should be returning a value of 3 not zero
I have created the below formula to calculate the number of projects by application (primary column) whose status is Not Started and belongs to group TMOEX. I should be getting a value of 3 but it is returning 0. Can anyone help identify what is incorrect in my formula? Thank you! =COUNTIFS({Project Status}, "Not Started",…
-
Does anyone else dream in Smartsheet?!? 🤣
I'm sure you've heard of people who dream in color. I dream in Smartsheet. Do you?!? 🤣🤣
