-
Index/Match Leaving Blanks + "#NO MATCH"
I apologize if this posts twice... I am a relatively new Smartsheet-er experimenting with the capabilities of the Index/Match function. I have two sheets, one that tracks project status, and one that I would like to link to the first, showing live project status updates by matching the ID # columns. I have created a…
-
Why is my IF(AND(HAS function only checking part of the AND statement?
I am using a checkbox column to return 1 if a row on this sheet matches the Student Name and Location Name on a row of another sheet. Formula: =IF(AND(HAS({Extern}, [Student Name]@row), HAS({Location_No_ID}, [Assigned Clinic]@row)), 1, 0) The result is showing a checkbox when only part of the statement is true. I need both…
-
Formula to show duration days in Months, Weeks, and Days
I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns are what I want to calculate with a formula (manually entered now to show what I want to see). For example, if something is 38 days, I want it to…
-
Visibility on Form Submission
Is there a way to increase visibility for requestors on their submitted requests? Like is it possible to send the requestors all of the requests they've submitted so they can see what they've requested, date, description, etc.
-
Introduction | Hello Smartsheet Community!
I am an Associate Director of Program Management based in Austin, TX. I've spent the last 7 years of my professional life working for one of the globe's largest and best-known interactive agencies. I use Smartsheet daily to manage multiple projects - both for client execution & internally based initiatives. I am considered…
-
Recommendations for Mass Comms Content Calendar
I'm researching different templates within Smartsheets that would best fit the needs of a few internal teams for a mass content calendar to manage scheduling for external outreach among overlapping constituents. On a basic level, we can enter information on the regular sheet grid and flip to calendar view as needed,…
-
Enter to Win a FREE Conference Pass to ENGAGE 2023 🎟️
Hi there, ENGAGE 2023: Potential Unlocked, our annual conference, is back again September 19-21 in Seattle and we can’t wait to see you there! And what is sweeter than being at ENGAGE? Winning a FREE conference pass to get you there! To kick things off, we’re launching our Sticker Design Contest (back again this year by…
-
Registration now open! ✨ Join us for ENGAGE 2023: Potential unlocked
Hello, I’m excited to share that early-bird registration for ENGAGE 2023: Potential Unlocked, our annual customer conference is now open! Whether you joined us last year or this is your first ENGAGE, share one thing you’re looking forward to in the comments below. ⬇️ You, our Community members, had such a strong presence…
-
Bonus Giveaway: A second chance to win a FREE ENGAGE conference pass. 🌟 Vote to enter!
Hi there, Did you hear we're offering another chance for Community members to enter to win a FREE ENGAGE conference pass? Everyone who votes on one or more of their favorite peer-designed stickers will get entered into a random drawing to win a FREE ENGAGE conference pass. (Voting on your own design is totally acceptable.…
-
how do I add a calendar view in a Dashboard?
Hello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able to see it. I don't want them to have any any interaction, just see it as a reference. Is this possible? Thank you. Jef
