-
Adding a checklist to a row
We keep our projects on a row-by-row basis. So, we keep all the information regarding each project in the row. We communicate about each project using the message tab on the row and keep all documents related to each project using the attachments tab in each row. The only thing I would love to have is a 'checklist tab' for…
-
WEEKDAY Formula not working
Hey all - I am trying to use the IF(WEEKDAY formula and it's not working. I'm so confused what I'm doing wrong, as I've used this same formula before with no issue. I'm wondering if it's my syntax, or perhaps my sheet? When using it, the error I get is "INVALID COLUMN FORMULA". Here's the formula: =IF(WEEKDAY([Nomination…
-
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…
