-
Report Grouping Work Around
I have a list of SOPs and their supporting documents (Forms, Logs etc). As you can see in the Excel example, we have the SOPs in Green and the supported docs below. Some, like the SOP Training/Retraining Record, are used for multiple SOPs. I tried: Using Gantt functions, added a Predecessor Column but I couldn't run a…
-
Using IF, FUNCTIONS (HAS, CONTAINS, etc.), and OR (for searched fields).
Greetings Team, I feel like I'm missing something simple on this one, but it's a general problem that I encounter a lot. For this question, I'm able to construct formulas that Smartsheet accepts, but the current version is long and more difficult to understand/manage from other users. This involves using IF, FUNCTIONS, and…
-
Do we have an update on Proofs being available in Reports?
Hello, My teams love having personalized reports but the function that we need the most is Proofing. Would there be an estimated time of when that the Proofing Function will be available in reports? Thank you, Johnathon S.
-
Schedule of Values
Has anyone created a sheet for Schedule of Values? Ultimately I am wanting to insert the project budget and tag the budget lines to the SOV lines. I can then go through and identify percent complete on the budget areas or on the SOV and it shows expected expenditures/profit. The best is if I have the budget and connect it…
-
Auto-populating Job Numbers
I've had a query from one of our Smartsheet users who are looking to generate consecutive numbers when we they are building rows of jobs. I've advised him of the Auto Number/System column type, which would help with this. He then needs for all children rows to be auto generated an asset number. His query is as below: If we…
-
How can I change the set up of work days in worksheet app?
I've read the documentation of how to set up, but it's a PC version, does anyone know how to change the set up in worksheet app? I just want to change everyday to workdays, right now weekends are not available for putting plans on it.
-
% Allocation <100% in sheet not flowing to resource views
I have users assigned to tasks on projects at less than 100% eg 40% on one and 40% on another. However when I look on the resource view (for all projects) the individual shows as 200% (100% on the two projects). Anyone know why and what I need to do to resolve.
-
Can I create 'placemarkers' for forecasting resource demands?
Can I create placemarkers by way of 'fake' users called 'SME Design, SME change Management etc' and assign to a future project instead of an actual person as a way to estimate future capability requirements. I note I need to add an email address with a user and wondered if I can use the same email address with different…
-
IF Y is blank, and X is not, take Date of X and add 90
i know this is not correct.. but. can someone help me fill in the missing pieces. =IF(ISBLANK([Renewal End Date]@row, [Agreement End Date]7, +90)) my goal is to have the Next Review column produce a date that is 90 days from either the renewal end date (if there is one) or the agreement end date Thank you in advance!🙏
-
Is it possible to create a conditional rollup for $'s OR display the max value for %'s?
I am working on a smartsheet tracker that can track the cost savings of specific projects on a month to month basis, then rolls up the total YTD savings. There is also an option for the users to enter their project progress as a percentage, in which case I would want the YTD column to display the maximum % from the year…
