Hello! I am working on getting a widget on a dashboard to show the next upcoming deadline, automatically pulling this information from the below sheet, analyzing the 3 date columns. I've tried several COLLECT formulas but nothing seem to work. Any ideas?
Hello Community! I have a question I wanted to bring to the table... I've been working on some processes and workflows for triaging work on my team. Requests come in through an intake form and we have automations to assign to specific resources based on the type of project/request that it is. Now, we are trying to make…
Just wanted to post a quick note here to recognize all our incredible Smartsheet Community rockstars! In my first ENGAGE as an Overachiever I got to meet several of you and made me realize how grateful I am for your support and how you’ve helped me get to where I am on my Smartsheet journey right now! THANK YOU!
Hello! I am trying to put together a formula that flags a project 'at risk' when: Deadline is in 3 working days or les from today Status is not complete, on hold or canceled This is what I have - but my challenge is getting trying to incorporate 'workdays' to the formula. I've tried several ways and it is not working.…
Hello! I am trying to come up with a formula to assign Quarters to a sheet, based on if the month is 1, 2, 3, etc. (Jan, Feb, Mar, etc.) I am trying to use IF(OR and I get it to work until Q2, but for some reason when I add Q3 section (highlighted) it is saying syntax is wrong. It is probably something obvious that I am…
Hello! I need to develop a formula to count the number of opportunities awarded this week and then compare to previous weeks. I have a helper column on my source sheet to list the week number for the awarded date. For Awarded Opportunities This Week the following formula is working: =COUNTIFS({Opportunity Intake study…
