Sign in to join the conversation:
I am trying to setup a Conditional Format formula to format a cell only when the cell contains a linked value of "Sheet Link from Cell in Other Sheet"
Shortest answer is to use a hidden helper column. Make a new column name it hidden and post the cell link at the top. Use an if statement, =if(columnheaderhere@row=$hidden$1,1,0 then use the conditional formatting tool to check if there is a 1 in the hidden column. When you are done simply hide the column.
GL
Good afternoon, I work at a community college and we don't currently have a CRM solution that will help me with the work I am doing. I am trying to create something to track current and future contacts on an organizational level as well as individual. One company might have only one contact but in the case of a larger…
Would someone need View permission to a worksheet in order to see the data presented in a report?
I have a form and the first question is a required field. However, I have five entries (out of approximately 400) that have come into the sheet with no data for this required field. Has anyone seen this before? Any clue how this happened? Here's what I've checked: blank space is not an option (form won't let me submit)…
