-
Saving & coming back to a partially complete web form
I'm trying to create a web form that allows my users to modify the form that they have previously started. Ideally to save the form and come back to it before submitting the form. Is there any way of achieving this? Many thanks, Neil
-
Gantt rollup for multiple projects
We are trying to rollup multiple project sheets that have tied in metrics. The gantt view is not allowing us to have the dependency arrows on our rollup. Do you have any suggestions how to create this? We have multiple tasks on our project sheets that have dependencies but our phases do not. I tried copying the dependency…
-
Report not reading contact list field from source sheet
Greetings Smartsheet Community! I'm having an issue building some reports. In my source sheet, "Art Requests", I have a contact list column called "Designer". This is where the project request (submitted via Form) will be assigned. I have defined the options in the dropdown. When I go to build a report to make one of the…
-
Approval Workflow
I created a workflow. The screen shot is attached. I was trying to see if when ready for approval is checked can approval status automatically change to submitted? How is that done if possible?
-
workday calculation with if conditions
Hi, I'm trying to add a workday function to my current calculation. I already use if condition in the cell. Here's what I have. If location is Riverside, then add 3 days to ETA. If location is Memphis, then add 5 days to ETA. IFERROR(IF(Location1 = "RIVERSIDE", ETA1 + 3, IF(Location1 = "MEMPHIS", ETA1 + 5)), 0) However, I…
-
Can I sort entries in Card View?
I have a task list organized in Card View, with conditional formatting to highlight critical tasks. Can I sort them in Card View to list the ciritical items first? Thanks, William
-
Need Formula to auto populate todays date when box checked
Please share the formula that will auto populate the current date or "Todays Date" in the Completion Date column when the checkbox is populated in the "Done" field.
-
Adding Positive Parents
Hello all, I am trying to set a formula up that adds the sum of several Parent lines, but only if they are positive. Adding all parents under one banner i use the Sum(Children) however, I tried to add only positive parents by using a SumIf(Cell1:Cell5, >0, Cell1:Cell5) but in doing so only managed to add all positive…
-
Can you assign muliple resources to a task without duplicating the row?
Currently, I am having to list the same task on muliple rows to assign different resources to them. Is there a way to assign mulitple resources to the same task without having to duplicate the tasks over and over again? There is a lot of repetitive content that is doubling the size of my Smartsheet.
-
Send a Form as PDF attached to an email
Hi, Could we have a form generated as PDF in Smartsheet and sent by email to a specific user (email address)? So this user could fill it and send it again. I checked we could have the form sent as link by email, but I need to know if it is feasible to transform it to PDF and send it by email. Any suggestion or solution?…