Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for October 2016
Discussion List
Add formula to column without changing last modified date
I would like to calculate the number of days an item has aged. We don't currently use a "closed" date field, but rely on last modified. =IF(Responsible1 = "Closed", NETDAYS(Created1, Modified1), NETDAYS(Created1, TODAY())) Is there any way to add a formula to a column without triggering the last modified system field to…
Default dates on web form
Hello All, I use smart sheet as project list and a web form as a work request. Our policy is that all request need to be submitted 4 weeks prior to their due date. Is there a way to have the duedate field on my webform defaut 4 weeks out from the date the form is accessed?
Changing the # of work hours in a day.
Should changing the hours in a day update the project schedule? For example, if the plan/scheudle is finished and based upon an 8 hour work day - shouldnt changing the work day in the project settings to 10 hours a day change the project schedule?
Dear Smartsheet Community Team....
Thanks for my bottle
Form Summary Email
Hello We have a sheet set up (for Travel requests across our business). We've set up a form for users to fill in with all the basic request details, which then populates the sheet. The admin team are then able to log into smart sheet and complete the rest of the row fields with booking details, costs etc. We've got an…
several sheets, one update request?
Dear clever people of Planet SS I have created a Report to summarise the Milestones shared in several critical paths all of which are on seperate SS's. I now want to send out just one 'Update Request' to one person who has the same task across all Crit Paths, but when i do this I get a message that I can only send multiple…
Help Using "IF" condition
Hi There, I need your help regarding "IF" condition. I want to create an "IF" condition to do the following job: " IF column 1 is checked, then show today date in column 2" Thanks in advance,
Webform view, Row Guidelines
Hi, 1) Webform View- not sure if this is already available but whenever you complete a form and you ask for a copy for yourself, you get this really nice tabulated form with all the entry that goes in a single row in the smart sheet. Could there be a view ( similar to card view) that allows you to see a particular row in…
Filtering on name
I am struggeling with fitering on name when generating reports. The filter in the report refers to the e-mail address of the user while the entry is the affiliated name. E.g I am not able to sucessessfully use negative filtering eg. show all that is not christopher.grinde@ge.com since the entry is Christopher Grinde.…
Base Line Construction program
How do i create a base line construction program that i can then overlay as constructed program to show difference between original plan and as constructed information
