-
Formula skipping rows
Hi all, I'm trying to use the below function to automatically change the color of Harvey balls to red, yellow, or green based on the length of time till a task's due date. =IF([Due Date]@row >= TODAY(+61), "Green", IF([Due Date]@row >= TODAY(=31), "Yellow", "Red")) However, for some reason some rows show "#invalid…
-
Using forms in mobile/app
Hi Everyone, We have a form which is filled by the site team. In one field, they have to update the remarks. It is a multiline textbox. But while updating it via mobile/app, there is no option of using 'enter' key to change the paragraph. Are we missing something or is it designed that way. Thank You!
-
Form Resubmissions
Good evening, I'm posting again in the hopes that someone can help me with an issue. I have a form that is being used to route matter closing requests from the attorney to Accounting to Records. I have a number of forms that were submitted (entries in the SmartSheet) but never went to anyone in Accounting because the email…
-
Can I filter a column but keep intact other rowsl?
Can I filter 1 column without it affecting the data in other columns? For example, filter only Bank Credits, but leave all other columns in full without removing any rows from other columns.
-
Cross Referencing Sheets
Hi, We want to create a sheet that cross references another sheet and only pulls in data relevant to the partner with whom we are sharing the sheet. The reason we do not want to use a report for this use case is that you cannot hide the comments from a report and we do not want them to see the row comments. Please advise…
-
Formula Quesiton
I have 2 columns - one Engagement and one Desired Engagement - If the two columns are not equal, I want the cell color to be yellow as an indicator. If the two columns are equal then, do nothing. How can write that formula in smartsheets ( since I haven't figured out a way to do it with conditional formatting)?…
-
complex if/and/or question
I have 5 status columns, each with 4 possible values (Approved, Approved with Comments, N/A, Resend). I want to fill in an "Overall" Status The 5 columns are __________________ Tagless Status Front Graphic Status Back Graphic Status Right Sleeve Status Left Sleeve Status Other Status My logic is If all of the columns are…
-
How do I send row data to an email contact in the same row every 30 days?
I am wondering if anyone can help point me in the right direction in setting up this smartsheet. We are trying to automate an email notification for over 100 employees for when they receive a time accrued balance at the end of the month. I was thinking each employee will have their own row with the time accrued balance,…
-
Is there a limit to how many unique forms I can create for a single sheet?
I am working on a solution that requires a unique url form for each client - I'm passing hidden fields in each form to indicate which client submitted the request - is there a limit to how many forms I can add on a single smartsheet?
-
Value of a cell is changed if a reminder is set on a row
Good Morning, I have the need to report on a master sheet when a reminder is set on another sheet. I want to be able to modify the value of a cell if a reminder is set and then I can link up that value into the master sheet. Thanks Juan