-
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 –…
-
Why is one of my users getting this "Can't Share Sheet" message?
One of our users is getting a message that "you have exceeded the maximum number of email recipients that your account can send to". This Smartsheet report is one I create every month and share to folks who then share to other folks for updating. We have used Smartsheet for several years and never had a user report this…
-
How do I create a predictive balance formula?
I'm not sure if this is even valid/possible, but I'm trying to create an accounting schedule which foresees upcoming payments and reflects the balance after the transaction. This image is a practice sheet with fictional values. In theory, I'd want the formula in Balance to always take the previous balance and add it to the…
-
Utilization Tool
Hello All, Has anyone created a tool for tracking PM hours worked on projects, that can go to a backend sheet and thus create a utilization number per PM? I have myself and another person on our team, and want to show active projects and then be able to track hours worked weekly on those projects. Ideally using a form to…
-
Printable and Readable A3 Gantt Chart
Hello, Could anyone advise on how to print a readable gantt chart in A3 format? I've managed to export it to PDF and select the rows needed, however it is barely legible. Exporting to excel has not helped as it deletes the gantt format. Would be grateful for any tips or solutions! Thanks
-
How can I merge two schedules for a project into one all-encompassing schedule?
Hi Everyone, I am working on a project that consists of two schedules, and there are tasks that will be done onsite for products being built for our company here in the US and for a location overseas (to be shipped out later on in the schedule). We have a schedule planned out for the US location, a separate schedule laid…
-
Why isn't our column formula updating on its own?
In our column formula, we have a date formula based on TODAY(), however, it does not seem to update automatically when the month changes. How do I get it to update automatically at the beginning of the month?
-
Cross-sheet VLOOKUP maximums
With the new cross-sheet VLOOKUP function, how many VLOOKUP cells can exist in one sheet? Does the limit change if there are both inbound and outbound VLOOKUPS in the same sheet?
-
Owner/Admin View for Workspaces (Hide unused Workspaces)
As our company admin for Smartsheet, I typically deploy all-new Project Workspaces - this provides me with the opportunity to assist team members if they become stuck, or have an issue; I can then problem-solve with them within their workspace. This leads to an issue where I have many, many Workspaces visible, of which I…
