-
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
-
Sales Totals By Year and Month
I'm trying to summarize our sales totals by year and then by month, based on a joining of the year and month from a "current ready to ship" date column. I'm using this for the January 2017 total cell: =SUMIF(yearmonth14:yearmonth51, LEFT(@cell, 9) = "2017 - 1", [P.O. AMOUNT]14:[P.O. AMOUNT]51) This method works just fine,…
-
Collapsing option for filter
Hi. It would be very helpful, if there would be an additional option within filters. With the help of this option it should be possible to preset the collapsing in the filtered list. E.g.: Option is set to level 2 => the filtered list is reduced to levels 1 and 2 but single lines can be expanded to deeper levels (if…
