-
Attachment Previews on Reports in Desktop App
Good Morning, I've had a few users in my ecosystem complaining that they can no longer preview attachments while working in a report. My user base only attaches PDF's. After some testing on my end I found some odd behaviors. This has become a quality of life issue, our production team utilizes a master report that pulls…
-
COUNTIFS and DISTINCT formula error
Hello! I am trying to count the number of unique customers from one column, that have been flagged with the year 2022 which is recorded in a separate column. Formula I have is - =COUNTIFS(DISTINCT({Customer Name}, {Financial Year}, "2022")) I am receiving the error, Incorrect Argument Set. Can someone help please?!
-
Report Not Displaying All Information in Dashboard
Hi all - I have a report which isn't showing information in one column (YTD Actual) but shows in the others (YTD Budget and YTD Budget - Actuals). When accessing the sheet, numbers are filled in the column so I'm not sure why they numbers aren't showing up on the dashboard. Column preferences are the same. Also, there is…
-
Absolute End Date Not to Change / Critical Paths on Grid View
I am trying to figure out how to sent an absolute end date to my project & then if any predecessors take longer than the original duration, & now the overall project timeline can't meet that date, it doesn't change the absolute end date....if makes you less duration of remaining tasks. Also, how do I see critical path…
-
Creating a Burn Down Chart
Hello, I'm a bit stuck on how, if it is even possible, to create a burn down chart. I'm importing raw data from Jira (we don't have the plug-in... yet) and we want to show a burn down of our defects backlog, along with optimistic and pessimistic and forecast. I'm able to do it in Excel so I've attached an image of…
-
Sheet Summary COUNTIF error when summarising formula driven cells.
Hi all, I'm creating a sheet summary report with the intention of summarising when passed tasks were completed relative to planned completion data i.e. early, on time, late. To do this, I'm using an =IF formula (which works) to define how to label tasks in my "Completion" column based on whether the 'Actual Completion…
-
Copy changes from Clone Workspace to Live Workspace
Hello all, We are working on a Workspace for a client and they have asked various changes to be made on their Workspace. We created a Clone Workspace to implement all changes and make sure it works correctly. The requested changes had to do with: Adding new columns to a sheet & update columns order Adding column formulas…
-
Forumla help sought so cancelled tasks are not counted as at risk
This formula surfaces 'At risk tasks' to a project rollup dashboard report. It does so based on the criteria of due date in the past and status other than complete. =IF([End Date]@row <> "", IF(AND([End Date]@row < TODAY(), Status@row <> "Complete"), 1, 0)) Question - What needs to be changed so that it does not surface…
-
Manufacturing Production Report
Hello, I work for a relatively small manufacturing company where our production managers meet every single morning, give their production numbers, headcount, etc to the manufacturing managers for them to enter the data manually in excel every morning. We created a form in Smartsheet for the production managers to enter…
-
How to hide attachments and Comments in Reports within WorkApps
We have some internal sensitive data saved as attachments that we do not want our clients to see. I have hidden the Attachments and Comments Column on the Reports and saved them as View Only within WorkApps. However, the users can still view the attachment even though I have hidden the Attachment column, by right clicking…