-
Using COUNTIF on a Range with Cross-Sheet References
I am attempting to use a COUNTIF formula on a column of cells that have VLOOKUP formulas pulling in information from another sheet. The COUNTIF formula returns a #NO MATCH. When I copy/paste the VLOOKUP info into text only, the COUNTIF formula works but this destroys the advantage of using a VLOOKUP formula in the first…
-
Columns Automatically Unhiding With Form Submission?
Hello all, We use a form for our open order sheet. We removed an item from our product list and I want to hide this item in our open order sheet (not deleted it, incase we add a new product because I already have all the automation and reporting set to include these columns). I have NUMEROUS hidden columns in this sheet,…
-
IF AND date issue
Hello, I hope you can help please. We use Smartsheet to prioritise our workload. What we want to do is to highlight if a task is due this week but we have not manually indicated it as a priority for this week. I have written an IF AND to use a red indicator if the conditions above exist and green if not. It seems to work…
-
Moved a sheet and now the data won't show up in reports
I had a full project plan in one folder. Then, I saved as new in another folder and deleted the original. The original plan was showing up in reports just fine. But, the new version will not show up in any reports. I have ensured that the new folder is selected when I build the report. I've even created test reports that…
-
Approval: two users/same level
Hello, Is there a way I can send an approval form to two managers who both need to sign off on each staff member's annual leave? I can do it if I send to Manager A first and then Manager B once the first step has been completed, but wondered if there's a way to do them both at the same time that I'm not seeing...?
-
How do I add text to the end of a formula?
I have a formula that calculates the number of days and would like to add the word "days" at the end of the formula. In Excel, I would use '& "days"' as in =NETDAYS(Added1, Closed1)&" days" ...
-
Red Flag If statement
I have an if statement that is doing what I need except when there is no value in the deadline column. I want to keep the functionality I have but make sure the flag is not red when I have no deadline set. =IF(AND(Deadline2 < TODAY(2), Completed3 = 0), 1, 0)
-
Unrecognized System Contacts
I'm seeing behavior in a sheet that I'm not sure if this expected or not. I am a known contact in our corporate instance of Smartsheet. The screenshot displays content in a sheet column that is created by submission of a form. For this particular column, it's populated from an email address in the form field. Submitters of…
-
Automated emails
I would like the ability to send an automated email to a sheet assignee at a certain time with attachments linked on that line in the smartsheet. preferrably I would like to be able to create a user group instead of a single assignee so that the email can be sent to multiple people but at this time it cannot be automated…
-
Averages with Errors
Hello, I'm trying to take an average of a range of cells. Some of these cells have a #Divide By Zero error in them because the source sheet does not yet have applicable data. I have used an IFERROR statement to change these cells into "blank" cells, yet when I use the following formula: =AVERAGE([Avg. Functionality]1:[Avg.…