-
Reporting Issue - Not pulling data from a Baseline Schedule
Hi - I have been using reports for a few months and just recently created a few Baseline reports to monitor Project Schedule changes. I have followed the SMARTSHEET method of creating the baseline and creating the report. My issue is that the report will not draw from the baseline schedule. I tried just by itself and no…
-
Resource View Filters
Anyone know how to add more than one filter to resource views... I want to see a Resource View of our Purchasing Group's users resources for all projects that contain "XYZ" or "ZYX"
-
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…