-
Formula for Hours Scheduled by Month
We're trying to determine how many hours we have scheduled in a month for a particular project based on the start and end date of the project. I can't quite figure out how to set the MAX/MIN without the EOM function. Can someone please help?
-
Using the same field across different forms in one sheet
Hi there, I'm working to build a request management system using forms where requestors will simply see a dashboard with icons/text and can select the type of request they need to submit. Since each request is quite different and I want to track the different types of requests, I'd like to list "Request Type" in each of…
-
How can we make GIS available to Land Agents without GIS experience?
In the charming town of Williamsport, Pennsylvania, between 2010 and 2012, a knock on the door carried an extraordinary weight of expectation. During this era, as America's real estate landscape slowly mended from a severe recession, families across the nation watched helplessly as their financial security and dreams…
-
If you believe Smartsheet is just an expensive version of Excel, you might want to reconsider.
Think of Smartsheet as a high-powered tool belt, not just a hammer like Excel. While Excel is great for basic tasks, Smartsheet is like having a whole set of tools that work together. It’s built for teams who need to keep track of projects with lots of moving parts. It automates the repetitive stuff, talks smoothly with…
-
Keyboard shortcut indent after CTRL+K went away
Thought I would start my own thread regarding this since it seems very quiet around this change. Am I the only one having no luck in using the suggested shortcut CTRL ] to indent? I am using Windows 10, Chrome webbrowser and swedish keyboard ( ] = AltGr 9) Ctrl AltGr 9 just types the symbol ]. Anyone else struggling with…
-
Header
I want to add a fixed header that displays above rows on my sheet. I see this is available when printing the sheet, but I need to add instructions and clarification to the published sheet that is viewable by collaborators.
-
If a value from Column A is found in Column B, can the occurrence be shown as "true".
Hello, I am looking for the easiest formula to help show when a value from Column A shows up in Column B. If it is possible, I do not want to enter each value found in Column A in a formula, as these values are actively changing. (Note: The list "Column A" is also extensive so manually entering each Active Project would be…
-
Duration as a formula to accommodate resource allocation varience
I have three columns in my schedule sheet. Duration (native column) hours and resource allocation. I would like the Duration to be my hours divided by my resource allocation. So If I plan to put 2 people on a 80 hours project my duration is only 5 days not 10. I tried a formula in my duration column but it doesn't allow…
-
Mandatory Comment on Approval Form.
Hello, How can we make the comment section in the Approval Form mandatory? like it is mandatory no matter what.
-
Print Baseline
Currently there is no option to add the baseline when printing- upon research it seems that for some reason this isn't an option. Can we get an option to add the baseline when printing?
