-
Allow 'Change Value' in Automations to add a functioning formula
Currently Change Value converts any formula added to text. Remove the " ' " to allow functioning formula to be automatically added
-
Shall We Play A Game? 🤖
How many words can you make from 'Smartsheet' using each letter it appears in the word?!? Ex: 2 'E's, 2 'T's, 2 'S's ✅
-
Adding sequetial number string
Hello I could use some help with this one. I got the formula to work in the "number column"…. but I cant currently get it to work as a column formula. Basically what I am trying to achieve is have it add a number in order if the "footer comp" column is unchecked. and miss is unchecked Right now it is counting but in the…
-
What’s Your Elevator Pitch for Smartsheet? 🚀
Hi Smartsheet Community! I’m curious—how do you sell the value of Smartsheet in 30 seconds or less? We all know Smartsheet can transform workflows, improve collaboration, and make life easier—but when you’re trying to gain buy-in from leadership or teammates, what’s your go-to elevator pitch? Here’s the challenge: Keep it…
-
Need help with INDEX COLLECT Formula
This discussion was created from comments split from: How do I combine multiple INDEX Collect formulas in one Formular?.
-
Form Logic based on multiple column selections
I've had few interactions with Smartsheet users in the Unanswered Questions that have prompted a form upgrade idea that I believe would be useful for many. It would be nice to have the option for logic on a form to trigger a response based upon multiple column selections. I have had multiple questions asked on Unanswered…
-
Using field from sheet to pull data into a form
Hello. Is there a way to use a field that is defined on a sheet to pull associated data into a form? For example, if I have a request ID for help desk tickets. I want to use a form to query or pull in the data from a specific Help Desk request ID, allowing a user to see what is in the record. Then, I'd like them to be able…
-
Average with exceptions
I'm need to apply a function to average a column (answer is correct (8)) if the other column (The nurse is caring for a a patient who dove into a) is NOT blank. I copied this over from an excel spreadsheet. I would like to keep the average in the top row. Right now it's saying "#unparseable" as the formula is not the same…
-
Error when saving sheet
This discussion was created from comments split from: Error Saving a Smartsheet.
-
Error! Column titles are not unique (1133)
I'm not sure why I'm receving this error. I created pivots for other reprts formatted the exact same way with no issues. I have one giving an error.