Hi, I need to add date/ day marker accross on my sheet for specific days. How do I do that? Please help! Thanks, SSH
Gantt Chart - Quarter Boundaries
The dropdrop only allows for Fiscal Years to start either in Jan, Apr,July, or Oct. What's the workaround, as many companies start their fiscal years in other months?
Stop scheduled update request for completed tasks
Hello, How can I stop a scheduled update request for completed tasks? In the update request functionality, can I set the field that should be used as filter to send the scheduled update request. For example, I have 5 tasks that I scheduled to request update everyday. Once the resource update the task as done, I don't want…
Will your next release have Baseline?
I am new to Smartsheet, coming from MS Project, here at new employer and I am in need of the baseline relative to the Gantt chart. Is this feature being worked on for the next release?
Is there a way to get the autonumbered Row ID to display in the web form that feeds my smartsheet?
It appears that system columns cannot be added to a web form. I need a way to assign a number to each submission that the submitter can see in the email that is sent back to them.
moving rows in reports (without using Sort)
Is it possible to move rows around in a report without using the Sort function? I have a report that pulls from 3 sheets, and I want to change the order of the rows from each sheet (not individual rows if that helps). Sorting only changes the order numerically or alphabetically, which I don't want to do. Any ideas?
Share only selected sheets from workspace
Hi all, I have multiple workspaces for different customers and I'd like to keep some sheets from there internal and some public, hence share with customers. Apparently I can only share a workspace completely. This forces me to have a lot of individual shared sheets, hence breaking the folder structure I would like to have,…
scroll in Gantt chart with magic mouse
How do I keep my scroll bars up? They always hide after I scroll, and switches pages when I swipe my hand too much on the mouse. Would like the bars to appear at all times like this:
Cell reference formula
How can I create a formula from two columns that will result in pulling in the value from a third column? Column1 (text) = Column4 Column2 (text) = 3 Column3 (date) = Column1 + Column2 Ideal Column3 result = [Column4]3 Please let me know if I can clarify anything, it is a little confusing. Thanks
Multiple Formulas: Formula SUM conflicts with Formula IF Logic
I have a sheet set up so that when a checkbox is checked, the price of a product generates in the column next to it. I also want to be able to capture the sum of everything in the price column, but when I input an =SUM, it reads as 0.00. Is there a way for the formula to calculate the sum of values that are generated by a…