-
I need to have a count down from Column A Date with the current date and show the number in a column
Colum A Date - has a date ( if in the future ) Colum B - should show me the countdown as per the current date
-
Calculate number of days per month within a date range that spans more than one year
I have a schedule that spans (2) calendar years. I want to return the number of days per month included in the range. Since I use this result for billing purposes, I have a column per month and year of the schedule the returns the number of days in that given month/year. I am running into problems once I get to the same…
-
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…
