You can add your phone number and message by typing in the boxes. Step 3 – Select Send SMS to send an SMS text message if a cell value changes Step 4 – complete the information required on the pop-up. This will immediately open the THEN window shown below. Once we’re done with the formula, click on Save & Continue.
In this example, we’re going to monitor Ad Spend Budget vs Realized so our formula will read F9>=G9 (when cell F9 is greater than or equal to G9, send me an SMS alert). This selection is basically telling Factivate that you will use a formula to trigger the SMS so all you have to do is write down your conditional formula to trigger the alert. Below the IF area, you will click on the text that says f(x) formula. Go to the actions panel on the right-hand side and click on the IF statement. It’s pretty simple huh? Here’s a step by step guide to have your spreadsheet send you an SMS alert when a cell changes using Factivate Step 1 – Open Spreadsheet Actions Menu > IF In this example, we’re sending it at a specific time interval so I will describe just how easy it is to send the SMS alert when a cell value changes.įYI – If you’re all ready to get this for your spreadsheets, you can sign up for Factivate or the Factivate Google Sheets Action add-on, here: Spreadsheet Trigger Actions Here’s a quick step by step video on using Factivate’s spreadsheet alerts to send you an SMS alert from your spreadsheet to show you how easy it is. The Factivate way to send an sms from your spreadsheet when a cell value changes (#easy #noprogramming)
#Send sms from google sheets how to
This is why I’m writing this post on our Spreadsheet SMS action: how to have your spreadsheet (Google Sheets spreadsheet or Factivate spreadsheet) automatically send you an SMS alert when a cell value changes. It’s our responsibility to tell people about this awesome functionality if we want to help them. Finding out about our spreadsheet actions has been relatively difficult so far. When I told him that he could have been alerted by his spreadsheet (either Factivate or Google Sheets) he was so mad that no one in his company had told him of this that he almost threw his drink against the wall.
I was speaking with a CFO yesterday who complained that he had missed a critical benchmark in a spreadsheet report he receives every week and it was going to cost him a pretty penny.
0 kommentar(er)
