Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Functionality Request - Egnyte
It would be incredibly helpful to have full integration and send documents into Egynte's document depository from Smartsheet.
Adding numbers that fall in a date range
Just learning Smartsheet. I need assistance creating a formula that will create a sum based on calendar months. I have two columns: one for a number of appointments, the second is a date column. As an example, I would like to have Smartsheet calculate appointments that fell in December. Thanks for any assistance.
Creating IF AND THEN statement
Hello I need help with creating if and then statement to perform the following. If Recruited From = Referral And Store Start / Transfer Date = Date Then Store Start / Transfer Date +90 days Here's the code I have and it's giving unparsable. =IF (AND([Recruited From]147 = "Referral", [Store Start / Transfer Date]147= DATE,…
Top Level of Sheets in Report
Hi. The top level of my project sheets contain the overall percentage and status and date range of all its child tasks. How do I display just this top row in a report? My current workaround is to have a hidden column that a mark and have the report builder only show the row with that mark.
How to change the sender email address when Sending Link to Form?
We use a web form as client survey but when sending it typically goes to the client's junk/spam folder because it's coming from "John Lee via Smartsheet <user@smartsheet.com>" instead of my email address which they have already interacted. This is negatively impacting our ability to communicate with clients as we have to…
Update Shared Users of functionality changes within a sheet
Does anybody know of a way to update all shared users (to a particular sheet) on new sheet functionality? It seems the only way to do this is set up a separate email where I have to pull out all the user names and send via an email client i.e. outlook. An option within Smartsheet would be much easier. For clarity, this is…
Incorrect Counting of Empty Rows
I am trying to count blank dropdown values in a sheet by referencing the column and it is giving me incorrect numbers. =COUNTIF([Sign Off]:[Sign Off], 0) It seems to be including the 10 empty rows at the bottom of the sheet too. Does anyone know how to get around this?
COUNT where cells <>"N/A"
Hi, I'm struggling to combine a SUM and a COUNT together (keeps returning an error). =SUM([CELL 1]22:[CELL 4]22) / COUNTIF([CELL 1]22:[CELL 4]22, <>"N/A") This returns a #DIVIDE BY ZERO. CELL 1 to CELL 4 could contain the numbers 1 to 5 or N/A. The end result is to provide a percentage out of 100% for the total cells with…
You do not have permission to edit forms on this Smartsheet
I am the Owner of a Smartsheet, ID #4329033635784580, and have already created 22 forms for it. I cloned the last one I created and edited it. When I tried to save it, I received the error, "You do not have permission to edit forms on this Smartsheet." Why can't I save this form on the Smartsheet? Is there a limit to the…
OFFSET FUNCTION
Hi SC, Does Smartsheet have an equivalent of the EXCEL OFFSET FUNCTION ? Thanks