-
Adding a Link to a Form
I would like to be able to add a link to a form so that a responder can evaluate a document and then respond to the materials in the link. Is there currently a way to do that?
-
#INVALID COLUMN
Hello Community; I have a formula to calculate a device's time run based off the start and stopped time. This formula is applied to 10 columns (generator 1, generator 2, etc. ) and it works, however, starting in the column for generator 2 and on, l am getting the #INVALID VALUE error. Any ideas how to fix it? Generator 2…
-
Column dependency on another column
Hi everyone, I want the cells in the next column to not be editable until I have filled an accurate values in the current column. For example: I want that nobody would be able to fill the Practices column before they chose the two values in the Lectures column.
-
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…
