-
Conditional formatting not sticking to exported PDF
Hi, I have a report that looks perfectly fine when viewing in Smartsheet but when exported to a PDF it throws in a grey fill. There is a conditional formatting that specifically says if the "Resource name headers" column is blank, keep that cell white - and it's a higher priority than everything else. Why is this happening…
-
Help! Trying to edit the automation of RYG balls!
Hello All! I am stuck trying to fix the automation of my RYG balls in Smartsheets! I need to add one more IF formula to be the formula below so that if a task has not yet been started, the ball will show up as gray. You can see from the screenshot below that all the other balls are working except when the task has yet to…
-
Fleet maintenance template
Hi there I am looking for a template to adapt to assist us with machinery maintenance on the farm. I want to be able to record work done and to set reminders for upcoming maintenance tasks. I am sure someone must have already done something similar with smart sheet - any help gladly received. Andrew
-
Countifs Issues with Date Columns
I am having issues with a formula that I try an use to count dates in a column that are less than the present day. With a modification the formula works just fine count the number of dates within the next 30 days. Both columns have conditional formatting associated with them, but the one giving me heartburn has the date…
-
Using formula in a Date column, then using SUMIF to total
Hi all, Relatively new to Smartsheets and I am looking for a bit of guidance here. I am trying to put together a 'Resource Forecasting Tool' for our company, wherein the users can populate either an 'Personnel Discipline' or 'Equipment Item' to forecast, they then will enter the start and end date and the quantity…
-
% complete report for multiple projects
I am trying to build a report that shows % complete, by project, across multiple projects (eg, Proj 1 = 50%, Proj 2 = 75%, Proj 3 = 10%) in one report view/summary. To date all I have been able to do is task level / individual project level % complete thanks!
-
% Planned formula
Hi to all, I need to add a % Planned to my plan. I used a formula but it didn't work. Attached you have a screenshot of my plan with the formula and the dates columns. Thanks for your advice!! Adelina
-
Find reports using a particular source data?
Is there a way to find all reports that use a particular sheet as source data? We have one giant sheet that is the mother of all our sheets, and we plan to make substantial changes to it but first want to know what reports are hanging off it. We want to quickly and easily find all impacted reports and resolve any issues.
-
List totals
I have a sheet that lists all of our clients by project. For reporting, i'd like to see a final report or dashboard widget that lists the clients name in order of most mentions within the original list. For example: List A Joe Doe Freddy Mercury Alice Chains Eddie Money Joe Doe Eddie Money Joe Doe Report: Joe Doe - 3 Eddie…
