-
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…
-
Total Cost Based on Date of Task Being Finished
I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily accessible. I have tried reports but that only displays all of the costs and does not…
-
Link to a File on/from Network Location
Is there any way to add a widget that will pull up a spreadsheet, doc, etc. directly from a network drive or PC location rather than a URL or Smartsheet item?
-
IF Condition issue
Hi, Can someone help me why i am just getting the value as Quarter if i change the value to less than 25 in column =IF([1.1 Landscape]1 > 0.0025, "Quarter", IF([1.1 Landscape]1 > 0.005, "Half", IF([1.1 Landscape]1 > 0.0075, "Three Quarter", IF([1.1 Landscape]1 > 0.001, "Full", "Empty")))) THanks
-
Filter for Current User with multiple contact column
I have created a sheet filter "my todo´s" for the current user. This works if only one contact is entered in the filtered column. But we have enable multiple contacts for that colum. Is there a possibility to build a filter "contains the current user"?