The help documentation states the following about cell references: “You can edit the name, referenced cell range, and source sheet of the reference.” If using a long formula and selecting the cell con…
Hello - I have created a report to display the current user's list of high level milestones. This list is supposed to display any milestone that is blank under parent child relationship. This ensures …
Hi everyone, We're putting together a stock sheet and we want to create notifications so that when a figure in a cell drops below a certain amount an email is automatically sent to the relevant people…
Hello community, I have a tricky question here concerning how to send out a reminder automatically based on the following idea. I have a sheet which lists the status of certain rows. Each row has a co…
Hi team, Could you kindly help me out with the formula syntax for the following scenario please: If the "Rag Status" column is 'Red', and the "Complete" checkbox is not checked, then the "Action Statu…
Hi, I was wondering about Project Management using Smartsheet. I am trying to create a project where there are many options or collateral pieces that key stakeholders can request from our marketing te…
I get a #UNPARSEABLE error on his formula. [Permit Agency Approved] is a date only column [Permit Agency Approved (F)] is a date only column =IF(AND(ISBLANK([Permit Agency Approved]9)), [Permit Agency…
I have two sheets, connected to each other via X-Sheet References. I tested this feature extensively when X-Sheet References came out http://ronin-global.com/2018/02/22/smartsheet-secure-your-sheets-w…
Hi, this is my first post on the forum. I use smartsheets for work but I have created this account to use the forums. I am attempting to create a formula that will allow me to use conditional formatti…
I'm building a task management sheet that prioritizes tasks by their order on the sheet. A formula calculates lead time of a task based on its current position in the list. Is there a way to dynamical…
