-
Create a checklist report to document end user review of records
I'm not sure how to tackle this one, all suggestions are welcome (thanks in advance). A project manager has 50 projects. They want to document that they have reviewed all project activities (tasks, reports, etc) monthly. So they are asking for a basic list of active projects assigned to them and an easy way to mark…
-
Limit on conditions in Report Builder criteria?
I have a report where I want to show results where: field A does not contain value 1 does not contain value 2 does not contain value 3 . . . does not contain value n Is there any upper limit to this or performance hit that you get when "n" is too large? If so what number is a recommended level not to exceed, 25, 50, 100,…
-
URGENT - lost data
Hi, We have a master data sheet which has other reports linked to it. We have been doing a lot of changes and updates this week but I've gone in this morning and there's big chunks of data missing. Could this be due to the fact that we deleted data out of the reports linked to it? Is it possible to restore from Smartsheet?
-
Percentage Complete Calculating Differently on 2 sheets
I have a smartsheet that is pushing data to another sheet. Percentages complete are part of the data that is being pushed. On the source smartsheet it shows 45% for a section. On the Target sheet it shows 63% complete for the sames rows. Can anyone explain why I am getting 2 different percentage completes calculated?
-
Lock or pin from Editing and Deleting. Even by Admin
Hello, I'd like to pin or lock or freeze a column from being edited as that information is going to archiving and doesn't need to be edited for the next 10 years. But I don't want to delete it accidentally, or edit the column contents. It seems like the lock only prevents Editors from changing the content. How do I make it…
-
Exporting Gantt View to PDF
Hello, Is there a way to export a Gantt chart to PDF and also include an image in the file? Thanks! Andrea
-
% Complete in a Filtered Schedule
Hello! I am new to smartsheet and am having an issue. We have a schedule where we have several different project type options. Depending on the project type, the project types that are not applicable to that project are filtered out and hidden. So there are several hidden tasks in each of our schedules. The problem I am…
-
Collecting data over time
I have a portfolio of 20 projects, the project manager of each currently provides me with a weekly estimate of their total capital requirement for the year via an automated update request in smartsheet. At the moment, this gives me a weekly static snapshot, but I'd like an automated way of seeing changes over time. Is…
-
How to make a list within the same cell?
Trying to list out multiple steps within the same cell - i.e. Action item 1 * Action item 1.a * Action item 1.b I need this to print correctly when exported to a PDF. Currently I am able to use 'alt enter' to make a new line within the same cell, but when i go to export it is incorrectly adjusted. Thanks.
-
if function for 3 criteria
Dear, I am planning to write an if function for 3 criteria. IF(AND([In Progress - Late]1 >= 1, [At Risk]1 >= 1),[In Progress - On Track]1>=1,) "Red","") I know I am writing it wrong. Can anyone help me structure the formula please? Cheers!
