-
Memorializing cell content
I have a column that calculates a date based on 'Column XYZ - 127'. This works perfectly. However, if 'Column XYZ' changes then my destination column will also change (obviously). But I want to preserve what the date WAS before it got changed. So I thought to insert a 'Helper' column and copy the date from destination to…
-
Date stamp does not trigger when Health changes in cell for a referenced value from another sheet
Hi all, I've followed the article Set the current date with the Record a Date action | Smartsheet Learning Center and was unable to get a date stamp to populate in a cell when a project's Health changes. Essentially we have a Project Rollup sheet which lists all our projects provisioned via SCC and the health values are…
-
Can you group columns?
I have a very large Smartsheet that contains contact info, partners, dates for various deliverables, financials, etc. I'm wondering if there is a way to group columns that reference similar tasks thereby make moving around the sheet a little more efficient? For example there are 14 columns that pertain to permitting, 5…
-
Any progress on Copy & Paste Columns
desperately need it!
-
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