-
formula for multiple criteria
i am looking for a formula to track progress / multiple statuses migrated = 100% decommissioned= 100% In Progress = 50% Incomplete - reporting error = 0% Not Started = 0% Failed in PROD = 50% Decom Candidate - 0% what formula can i use to get a update in a column if any these statuses reflect
-
extract city & state from a city, state, zip cell
I want to extract the city & state from a cell that has the city, state and zip code. The zip code may not always be 5 digits (either 90210 or 90210-1234) and the City and State may not always have a comma separating them. A formula that can extract any text left of a numeric value is what would solve this, but I cannot…
-
How can I change Community profile name
I have set my nick name in the community profile and wanted to change back to my original name
-
Im using Sales Pipeline Overview Dashboard, but want to have a pipeline sheet per rep
How would i link a new duplicated sheet to a dashboard, lets say i want to use the Sales Pipeline Tracking Template, but i want each of my reps to have their own Sheet-Sales Pipeline that reports up to the Dashboard. Is this allowed?
-
[Event Recap] Jumpstart 2024 with Community
It was a pleasure to see so many of you join us today at Jumpstart 2024 with Community, where we got to celebrate your collective achievements over the past year and share some exciting updates planned for the Community platform. We were joined by members from around the globe including but not limited to: India, South…
-
Using IF
Can you please suggest what is wrong with this formula? (Priority Level and Modified are both columns. Priority Level is a dropdown, Modified is the automated modified date. =IF([Priority Level]@row, ="High: Within 2 business days", (Modified)@row) I am eventually trying to get the formula to add 2 days to the modified…
-
[REMINDER] Jumpstart 2024 with Smartsheet Community is tomorrow! 🥳
Hey hey Community, it's almost time to jumpstart your year with us! Our Jumpstart 2024 with Smartsheet Community party is tomorrow, and I wanted to leave just a few reminders: Remember, you need to be a registered Community Member and have signed up for the event to join. ✔️ And good news: We had a few more spots open up,…
-
Jumpstart 2024 with Smartsheet Community - Giveaway!
Hey, Smartsheet Community, Are you ready for Jumpstart 2024 with Smartsheet Community? 🥳 Let’s start the party with a giveaway! We want to know: What’s one word you’d use to describe 2023? (Keep it clean, y’all). Leave your answers in the comments below for a chance to win a Yeti mug 👀 and run back to the party! Make sure…
-
Hello
Hi There SMARTSHEET Community! My name is Stacey and I look forward to asking a lot of questions! 😁
-
SELL OUT UPDATE [Virtual event] Register now for Jumpstart 2024 with Community 🥳
👉🏻 We've opened up just a few more spots - register now before they're gone! Hey Smartsheet Community, 2024 is here, and we’re excited to kick off the year in style with a FREE hour-long virtual event for all registered Smartsheet Community Members and peak humans! Other than great music and energy, you can expect:…
