-
Send notification without access to sheet
I am wanting to create a workflow that will send a notification to a contact listed in a row without allowing access to the sheet itself. Specifically, when I receive a notice to vacate from a resident in one of our apartment buildings, I would like to send them an acknowledgement that it was received when its added to the…
-
Is there a formula to count how many times todays date is entered into a sheet?
-
Automatically delete blank rows when using a Form to add to the bottom of a Sheet
I'm submitting this enhancement request, but this should really be viewed as a glitch or break-fix. It makes no sense why blank rows would appear when submitting via a Form. This is a core function of Sheets and should be more streamlined. Manually deleting rows is incredibly inefficient and has already lead to multiple…
-
How do I count the reason for the consult, AND the year it took place?
I tried to amend this formula to report by year. Below is the formula I tried, which didn't work. The reasons are part of a drop down on another sheet. The consult date is on the same sheet, but the full date is in the cell, 10/12/2017, 11/1/2017, etc. My current formula in the TOTALS to DATE is: =COUNTIF({Reason for…
-
Can a COUNTIF formula "count" when there are multiple values in one cell?
I've created the following formulas to count how many times a person's name is appearing in a configurable (Contact List) column for Project Lead and then Assigned To on another sheet: =COUNTIF({Project Lead}, Primary@row) =COUNTIF({Assigned To}, Primary@row) The Primary@row is directing to the name of the person I have…
-
How to capture/log user/contact info in a cell after updating a different cell?
I want to be able to identify the user when changes are made to cells on the Sheet. I know there is the Activity Log. But I want to see that data on the Sheet. I also know that there is the Modified By column, but that picks up changes to any cell in that row. I have a log that needs to have the status column changed by…
-
Output combined column name values from checkboxes.
Hi, I have a number of checkboxes, if they are checked I want to output the column value in another cell. I understand we can't reference the column values but I am able to do this: =IF([Red]1, "Red") This will return a single value if the checkbox is true. When I try something like this: =IF([Red]1, "Red", IF([Green]1,…
-
Is there any way to select only specific columns to be included in alert messages that are sent out
Is there any way to select only specific columns to be included in alert messages that are sent out using the SmartSheet Automation feature? Currently, I set up an alert. And it displays all of the columns, even if I hide certain columns in the sheet. I'd like to be able to select which columns are sent and included as…
-
Need report and forms to track client status
Working on a project with about 680 customers managed by 8 customer success managers. I need to track each customer's status throughout the project (will run through the year) with about 5 milestones. I'd also like to have a form so the CSMs can easily update the client's status after speaking with them, and a dashboard or…
-
Date Calculation not working correctly
In my Operating Calendar sheet, I have a Due column (date). This due date column should be calculating based on a formula that adds the "Days From Pricing Group OR 1st Departure Date" column to the "Pricing Group Date" Column (=[Pricing Group Date]@row + [Days From Pricing Group OR 1st Departure Date]@row). Both the "Days…