-
Setting up Days Outstanding
Hi all! I need to fix a column in Smartsheet. The column that says "# of days outstanding" does not always automatically fill for us. How do I fix this, do I have to put a formula in each cell? Also, smartsheet newbie here, I've been working in it for about a week, so I might need extra help. Thanks in advance! Laura
-
Turn off smartsheet system alert
Hi, Is there a way to turn this notification off permanently? I don't want to use the function (ever at the moment) but the first time I assign an allocation on every new sheet, this pops up and I have to choose "not now". I would really like to say "not now and don't ask me again". Is that possible? Thanks.
-
Uniform Inventory
Does anyone have a use case where they track uniform requests? We have a 8-10 types of uniforms that vary in sizes. I need to track (via form) what people want, and have it pull from our inventory. I'm just not sure the best way to set up my sheet. Any ideas are welcomed!
-
Image In Parent Task Reference Broken
The following PARENT image cells in Grid View used to transfer to a image in the CHILD. Now, instead of having the image, in this case "hr.gif", display inside the card in the Card View, the card displays "hr.gif". Can this be fixed to work like it did?
-
Formulas // How to set up one sheet writing to another
I created a project request form for one of my team members -- others on the team enter a request by filling out the form, and so the sheet becomes his workload queue. Another team member has a schedule on a separate sheet with some items assigned to the same resource. She asked if there is a way that if she selects his…
-
Auto-send PDF Gantt chart of project schedule
We want to be able to auto-send a PDF of projects to our clients on a weekly basis. Can we do this somehow? I know we could share a report for them to view at their own convenience, however, we can't be sure that they will log on to view it regularly which is necessary. to make it easier for them, we would like the option…
-
How many cascading multiple sheet dependency can smartsheet can do?
HI, Its me again doing cascading dependency on different sheets. I tried 2 cascading project sheet dependency and it works. I try doing 3 tomorrow but a question lingers: How many cascading multiple sheet dependency can smartsheet can do without any issue? Thanks D Micu
-
Can a Smartsheet form submitted auto-populate PDF then triggers DocuSign
Hi, I am trying to deploy a reimbursement system for my office. Once a person submits a form via smartsheet, I need to have a PDF pre-filled with all of the info including the ones that will be linked to other cells. Once the PDF is prefilled, I will need it to go thru DocuSign for signature. Once the user signs I will…
-
Removing duplicate types in an output report
I have a report that shows the output of staff within a department. It shows all the publications and events they are working on. I am looking to build the report so that it does not show duplicates of the same type of output by the same person. For example, Staff member A is running 10 roadshow events throughout the year.…
-
Renaming columns affects reports
Why is it that changing the name of a column in a sheet breaks all the reports that include that column? I need to go into each and remove the column with the now defunct name and then add the column back into the report again. This is tedious and frustrating (what if I miss a report?). Fortunately conditional formatting…