-
Issue using COUNTIF function with OR condition where OR is reference to different sheet
I am trying to use COUNTIF function with OR condition where the OR is referencing to different sheet. It’s the OR that's causing me issues. When I refer to same sheet reference its working fine but when I use different sheet reference I get “#Invalid Operation” error. Formula that I am using is =COUNTIFS({Primary_Owner},…
-
Check a Date Range
I need help with defining a formula to evaluate a date. I have a “Date” column which contains a mm/dd/yy date. I want to evaluate that column to return “Yes” if the date is within the current month and the next 60 days. For example: “Date” = 07/10/22 Today’s Date = 07/22/22 Is the “Date” within the range: 07/01/22 –…
-
Thank you all for joining the Community Scavenger Hunt! 🎉
Smartsheet Community! You all showed UP for our launch and celebratory Scavenger Hunt! Did you have fun? I hope you're digging the changes and ways to connect with other Members. Your energy gives us energy. A note that the Scavenger Hunt is now CLOSED and we have contacted the 10 winners. But don't dismay if you didn't…
-
Trouble with IF AND formula - i need some help :o(
Hi everyone, need some help, I need a formula to display 5 different outputs based on the conditions set out below, I have tried this based on a IF(AND formula and not getting much back, I can get 4 and 5 to work using =IF(Cancelled@row = true, "5. Request Cancelled", IF([Upload to IMS]@row = true, "4. Request Complete"))…
-
Meet the new Smartsheet Community + join the scavenger hunt to win! [CLOSED 6/23] 🥳.🔍 🗺
Welcome to your new Smartsheet Community! Thanks to your feedback, we’re thrilled to re-introduce you to THE place to get connected with people around the world who are driving achievement at work with Smartsheet. Jump in and explore the new platform by completing the site-wide scavenger hunt and you’ll be entered to win…
-
Edit Posts in the Community Forum
It would be great if you could allow a way for us to "edit" our own posts. Occasionally a typo is noticed only after submitting the post and I feel it would be a nice addition to allow us to fix any mistakes we may come across after submitting a post.
-
Workspace at work
The home spot needs a touch of TLC, but same sort of jam going on the bread there.
-
Celebrate the new Community and join the hunt on June 14 🔍 [CLOSED 6/23]
UPDATE: The Scavenger Hunt is now live until June 23! As we teased a few weeks ago, the Smartsheet Community is about to get a makeover on June 14! To celebrate, you're invited to a site-wide Scavenger Hunt! Once the hunt goes live next week, complete the tasks and you could win one of 10 giveaways of a brand new…
-
Getting started: Create an account
In order to ask or answer a question or create a post in Community, you must first set up an account. To get started, sign in (use the Sign In with Smartsheet button in the upper-right corner of this page).You'll use the same credentials—email and password—in the online Community that you use in Smartsheet. The first time…
