-
Vlookup functions not working on a Master Spreadsheet
My colleague and I, who do extensive work on a master spreadsheet that pulls data from many different sheets, are having a lot of trouble with the vlookup function on this particular sheet. We use the vlookup function in multiple different columns on the spreadsheet in question, pulling data from a different source sheet…
-
How to include formula to perform a count from the keyword in the row and update the count?
Hi expert, Not too sure if this is supported within the function. I have a used case below, I need tester to input their test result in name assigned in the column (Col E-G). Once they input the status = "P" or "F", the Column 'Total Pass' and 'Total Fail' will do the count base on the condition keyword P or F in each row…
-
Median formula showing highest value from range.
Hi everyone, I have two sheets, a master sheet with cost data and a metric sheet with formulas to get a summary. In metric sheet, I need median value of certain items. I have used MEDIAN & COLLECT. Problem: When I updated the formula, I got the correct median value. But after sometime, the metric sheet gets refreshed…
-
How can I convert YYYYMMDD to a SmartSheet date value?
I have about 2500 date values, imported from an Excel spreadsheet, in the YYYYMMDD numerical format. I would like to convert them to Smartsheet date values. Any suggestions?
-
Is there an automated workflow that populates data in cells based on triggers and conditions?
Hi Smartsheet SMEs! Please share any success you've experienced in creating a workflow to automatically populate cells using select triggers and conditions without using a formula. Thanks in advance for your feedback/suggestions. Edwina -
-
The correct VLOOPUP formula?
Hello I am needing a formula that will pull an employee level and assign it to the alias listed. I have used differed variations of VLOOKUP and nothing seems to work. Breakdown: Sheet #1 will contain a list of an employee alias's, sometimes the alias will be listed multiple times. In the column "Level (Formula)" on sheet…
-
Reviewing past personal messages?
When inviting sheet collaborators and giving them instructions via a personal message, if i do not Cc myself on the message, is there a way for me to see what was originally sent, or is the message gone?
-
Date-Time vs Date - Strange Behavior?
I noticed that if you neglect the fact that a date-time is not the same as a date, you get unexpected results. If you look at the image you see a date-time and a date column that is set to equal the column to its left. As you can see it does not produce an error, and it populates the date. However, only in certain…
-
I would like to copy rows to another sheet but....
I would like to copy rows to another sheet so that other departments can view /work out of the copied smartsheet. What happens if the master's columns are increased or deleted? Is Smartsheet able to match the rows into the correct columns?
-
Assigning One Person to Another Person
I have AR Specialists that are assigned to Property Managers. Each time I enter a new property and select the Property Manager from the drop down list, I want the AR Specialist column to automatically populate. If the Property Manager in column 1/row 1 = XX or XX or XX, then the AR Specialist = XX If the Property Manager…