-
Sumif column name contains "Tax"
Hi All, I'm using smartsheets to track scores from daily quizzes taken by members over several teams. The end goal is that we want to compare the total scores from each team in a dashboard, so I'm trying to use the sheet summary to calculate the totals. Basically, each column on the sheet has one employee's name and the…
-
Sticker for ENGAGE 2022!
I wanted to showcase the sticker I created for ENGAGE 2022!
-
Data Shuttle Kicked off by Power Automate Flow
I am using a Power Automate Flow to create an .xlsx file and then run an Office Script on it. This is done within 1 flow in Power Automate. The file is saved to One Drive. Currently I have a Data Shuttle that I run manually to take the updated file and load to Smartsheet. Is there a way to use Power Automate to run the…
-
Dashboard - how to change Metric Widget data source after time of creation
How do i change the data source of a metric widget? You can 'add data' but this adds a new one. In my particular use case we can now copy and paste widgets between dashboards, however this is no way to edit the data, ie use the widget as a template. For me, we have a standard project template, and want a standard dashboard…
-
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.