-
Tasks list report - from different sheets with different column names
Hello! I have a problem with my task report , when I want to filter it for one specific person. I have 3 columns, from 3 different sheets and they all have their own column name for "Assigned to", such as 1, Assigned to, 2, Responsible person and 3, Responsible. And I do not if it is possible to filter from these 3 dif.…
-
Document Builder - text field not populating due to size
I have an adobe fillable pdf file and have checked that there appear to be no maximum limits to the number of characters in a text field. I map a smartsheet text field to the adbobe fillable text field and...........it is not populating for some rows but is populating for others. The problem appears to be the amount of…
-
how to copy one cell value to another in workflow
Hi all, In a workflow if a trigger occurs I would like to copy the value of "cell A" to "cell B". This seems not to be possible or is there a workaround? Thank you, Joachim
-
Days Until Next Task Due
Hello, I have a column of upcoming task due dates, and would like to compute the number of days until the next upcoming task. I have read about =MIN(COLLECT but can't seem to get the formula correct. I know the >TODAY function should be included in the formula somewhere as well. Thanks!
-
Returns value with matching data (cross sheets)
Hello, I have a sheet to receive project requests with reference, descriptions, and team members in 2 columns, the main person-in-charge, and other team members (multiple contacts). There is also a project status column. I have a separate sheet for respective project members to update on the status, e.g. Jose. I would like…
-
How to restrict Update Request to only notify of incomplete tasks (involves Parent/Child rows)
I have an automation to send an Update Request for incomplete tasks. The sheet is structured with Parent/Child rows. The problem is the automation is reminding owners to complete work that is already marked 100% complete. Automation: Trigger: when a date is reached (every 2 weeks) Condition: where "100% Complete" does not…
-
Wrong Sub-Task Names Are Used on Notification
Each notification my team and I receive is labeled "Buyer's Order" changed. However, in reality, the task that changed is named something different, like "Placed Insurance". How can I modify so that proper sub-tasks names are used on the notification? In addition, I would like to add the main task to the notification as…
-
Printing Dashboard to pdf not the same for all users
Hi All, I have created a dashboard that needs to be printed by different people. When I print to pdf it looks perfect, but it is different for other people. E.g. One person is missing all text in one Rich Text widget, and the widgets are misaligned on each page for another user. Background graphics and Headers&Footers are…
-
Dashboard Widget Not Calculating
I am really struggling with this one! On my dashboard, I have a widget that calculates a count of my status items by color. As you see below, Blue status is tracking at 47 but my Green status shows 0. When I click on the Green status, my report behind it shows 11 items (sample below) When I edit the widget, and go into…
-
I need help to setup a structure with parent child relationship like the diagram below