I have A1 and B1 which are two different dates (for illustration: A1 is today's date, and the other in the following day). I have data value in Cell C that is changed daily by another cell linking formula from other sheet. Then I have cell A2 and B2 -- the formula in these cells is: =IF(today()=ColumnA1,CellC) and…
I sent out a series of update requests that I now found out went into recipients' junk folders. How can I prevent this in the future?
I have a number of update requests that I've set up to "trigger" from a column that calculates the number of networkdays left before a due date. For example, I want a manager to update the page count of a report 3 days before that report goes out to an editor so that we know if the length has increased. But, if that…
I am a new user of smart sheet. I have recently just set-up smartsheet as a tool to track around 200 customer work requests that are going through a University manufacturing workshop. The nature of the work means that there needs to be a reasonable amount of exchange of information between the technicians doing the…
Can you share contacts or contact groups with other smartsheet users? Similar to how you share a filter or another way?
HI , I Have set up an Approval Request Which works amazing My only Issue is that my client that needs to approve the job Request Gets in his email for each Request line an email but its an auto Reply to the Previous Request Is there a way by the delivery settings to set that the subject of the email should always Reference…
Hi all, Was wondering if there is a way to send notifications (alerts & reminders) to the entire sheet (all rows at once) whenever a user needs and not by a pre-defined rule? For example, the sheet owner want to be able to send update requests or notifications in the middle of the week, not in a specific day that he/she…
Can you create an update request to have Smartsheet read incoming data being added to a new row for duplicate information? We are considering creating a web form for people to "register" with us and want to prompt them (or our staff) if they try and register twice.
It seems as if there's no way to change the rows to be updated in a recurring update request, currently. I think that this is very inconvenient and undermines the power of recurring requests: * I don't want to bother project managers with requesting status updates on already completed rows * I don't want to bother them…
Both Google sheets and Excel have a shortcut (CTRL+~) that allows you to toggle a view that shows all the formulas in the sheet at once (that is, the cells change from displaying values to displaying the underlying formulas). I find this very helpful to: - Discover which columns I want to shade grey to indicate that they…