-
Pulling Email Address from Another Sheet but as a Contact
In Sheet 1, a user enters a course code (e.g., BUS 123) in one column. Smartsheet searches for that code in Sheet 2, finds the corresponding program leader's name and e-mail address, then puts them in two cells in Sheet 1. Now Sheet 1 shows the course code in Column 2, the program leader's name is Column 3, and the email…
-
Auto-filling columns in Smartsheet
I have created a form which captures computer name, name, and email address of the person on the smarsheet in addition to the other data they are submitting. Is there a way I could use the formula to auto-fill name and email address for repeat users referencing the machine name either on the form or on smartsheet?
-
Formulas in Contact Columns
Please please please make it possible to use formulas in contact columns! :)
-
Automation: Request an update but my contacts are not in a contact column
I'm working on a sheet that has a formula that is running an INDEX/MATCH to populate the Carrier Contacts based of the trucking company's Unique SCAC code. The fomula is working great now and I have the cells populated with the email contacts for the carriers. I am now trying to write an automation "Request an Update" but…
-
Formulas: Use of IF and JOIN
I am not the most savy when it comes to complex formulas. I am trying to figure out if I can combine an IF Text with a JOIN. I am trying to join only certain items when TEXT is found in the first cell for a naming convention sheet. Is this possible?
-
Formula Assistance (SUMIFS, COUNTIFS of CHILDREN)
I'm having difficulty with a few formulas wherein I'm attempting to SUM and COUNT only the CHILD rows so as to not duplicate amounts or counts (ie. need to exclude the Parent Row). The formula below works when the BOLD text is not inserted. The issue is that the potential exists where the sum and/or count will include the…
-
Make Cell Blank if all Columns are "N"
Hi there, Wondering how to amend this formula so that if all the cells are "N", it will return a blank in column "Report Status" =IF(OR([PAR Items]16 = "Y", Proxies16 = "Y", Commissions16 = "Y", Constraints16 = "Y", [APX Reports]16 = "Y", [MRFP/SMA]16 = "Y", Commentary16 = "Y", Attachment16 = "Y", (COUNTIF([PAR…
-
Automation: Request an update but my contacts are not in a contact column
How can I work around this issue. My sheet is populating the "Contacts" via formula. I want to trigger automated update requests but am running into issues since I'm unable to convert the column type to "contact" since it appears that Smartsheet doesn't allow this functionality. Anyone have any ideas how I can work around…
-
RGB Balls IF Function on 4 Colours Rules
Hello everyone, sorry if my grammar is bad. I am Chilean and I recently use Smartsheet, I have learned a lot in a short time. Now I need to solve this formula. Grey = IF Stock Column is “ “ (empty) Red = IF Stock Column is “0” Yellow = IF Stock Column <= Critico Column Green = IF Stock > Critico Column Could you give me a…
-
List of all ranges defined for a sheet
Hi Folks, We have been using a lot of cross sheet links and need to clean things up. Is there a way to see all the named ranges used to access data in a sheet? In other words, show all the ranges and thus the sheets, that are using data from the current sheet? Thanks!