-
Workback
Hello, I am relatively new to smartsheet and I can't seem to figure this out (I am sure it is easy, so sorry for the dumb question). I have end dates and durations secured and I would like the sheet to populate backwords based on the end date and I can't figure out how! Thank you for your help.
-
SmartSheet Forms - Populate with web data at submission
SmartSheet API's make it easy to interact with data coming OUT OF SmartSheet. Is it possible to capture web data (in particular from a URL) to prepopulate certain values? Use case: Survey - user is logged in and is responding to a survey based on an item they are viewing. Need to capture user details (User ID, First Name,…
-
Hours NOT adding up to correct number of days
I'm having a challenge where the total number of hours is not adding up to 1 day if the hours are equal to the "length of workday" under my settings
-
Task duration over a longer time frame, not consecutive days
I often have tasks that I know how long they will actually take to do, but just need slotting in amidst other works eg a 2 day job, but it needs to be within the next 2 weeks (10 working days). So it may be worked on 1 day in the first week and 1 day in the next week. If I enter the the period it can be done over, using a…
-
Date based on another date
Hi All, I am new to this and was wondering if anyonecan help me with a date formula? I have a column 'Urgency' that uses dropdown choice - Critical, Urgent, High etc. Each choice has a set amount of time to be completed... Critical = 1 day, Urgent = 2 days etc. I have a 'Due Date' column that I would like to be populated…
-
Smartsheet Developers
The reason I purchased Smartsheet is because I'm overworked and understaffed. I simply don't have time to build all the sheets I might need. How can I find a veteran user or developer to help me create what I need?
-
Error Message "Error: this link is invalid"
When linking from Sheet1 to a cell in Sheet2 I am recieving the Message "Error: this link is invalid". What is causing this? The dates in Sheet2 are driven by Sheet1, BUT there are no dependencies that set up a circular reference. I am wanting to bring back start date/duration for information only. We have been having some…
-
Customize fiscal year
How do I customize a fiscal year in a Gantt chart. For example, my fiscal year starts in Aug on a specific date - is there a way to customize the timeline so that it uses my fiscal year start instead of the default options?
-
Uploading my Picture into my Community Profile
I've tried several times to upload my picture into my Community Profile. I select Edit in my profile, I get the screen that currently has the picture blank, I click select file, go to the folder on my computer, select the pcture, nothing happens. I'm able to upload that same pictutre to my website, it's a JPEG 475 X 613,…
-
Gantt Chart layout - weeks
I am aware that you can create a Gantt chart view by showing the week of the year. Is there a way to configure the layout to show the project week? Thanks for any assistance. Mike