Is it possible to create a similar format in Smartsheet?
The numbers below each date indicate the number of people/site workers working on the project on that particular date.
Hi @Abhiraj Joshi ,
if you have access to the resource views, then yes, but not in figures but the names and capacity utilisation.
If you need to have this as a sheet, then you have to build it and it will be some effort. It looks like you currently do it in Excel. If it works there, you most likely can do the same in Smartsheet with the same logic. The formulas will be a little different and the structure of the referenced sheets need to support this.
You could use formulas with cross sheet references to search other sheets for the number of people working for the same (unique ID = project name or number) project. The difficult part is the timeframe (rolling, fixed).
Hope this helps
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Thanks for the suggestion.
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.