-
Merge columns in Sheet 1 and Sheet 2 to Sheet 3 - Vlookup
I have Sheet 1 with columns Employee ID, Employee Name, Employee Address. I have Sheet 2 with columns Employee ID, Salary, Address, Status. I need a Sheet 3 which has columns Employee ID, Employee Name, Salary, Status from sheet 1 and sheet 2. I am trying vlookup : =VLOOKUP({Test Range 1}, {Sheet 1 Range 6}, 2, false) This…
-
If checkbox checked, replace text content in another column
There is a text column (AAA) that contains a URL. If a checkbox in the column "BBB" is checked, that URL should be replaced with "In the DB." I've tried using a 3rd formula-devoted column, but so far no love. How??
-
Help with vlookup or match based on a predecessor row
I'm fairly new with smartsheets and trying to build an automated system where the task ready box is checked when % complete column is marked 100% based on the predecessor row. Would a vlookup or a match would work? Any help would be greatly appreciated! Currently I have this equation, but am hoping to not have to manually…
-
Countif with Month Formula
Hi, Need help with something that should be quite simple. I need return the count of "quotes" created in January. Right now, I have the following: =COUNTIFS({Quote Date Column}, MONTH(@cell) = 1,({Quote or Order Column},"quote") Can anyone tell me what I need to change? Greatly appreciated!
-
Can I Convert a Name into a Contact within Smartsheets?
I used a formula to index and collect who the party responsible for a certain task is, but I want to be able to replace that written value with the contact information of that person. The "Responsible Parties" column is a contact list and I'd like to almost use a "find" function or something along those lines to…
-
Can you re-trigger an approval workflow?
I have a couple different scenarios that I've run into. The first is that the end user is saying that the approval request isn't coming to them, so they can't approve anything. The second scenario is that the approval goes to a person that they wrongly identified and we need to re-route the approval to the appropriate…
-
donut chart from multi-sheet report
i have this report summing up approved, payed or overdue quotes from multible sheets - each showing a different month how do i use only the sum of all columns to make a chart?
-
Looking for help - using index/collect potentials
I am working on a complex workspace/sheets for a sales team with commissions and quotas. A while back, I was able to get a index/collect formula to pull in the correct tier for a quota plan: =INDEX(COLLECT({Quota - Lauren 2021}, {Quota - Lauren Minimum$ 2021}, <=[Commission MRR]@row, {Quota - Lauren Maximum$ 2021},…
-
Index/Match Mismatch
I must be making a silly mistake or be completely wrong - any help is appreciated. I'm fairly new at this, but learning. I have a sheet that is largely based on submissions from a form, with additional columns to pull in information from other sheets. I have similarly used Index/match on other sheets, I believe in the same…
-
IF Function
I'm trying to use the IF function for 3 different columns, using a comma after each "Green" and adding ))) at the end of the formula, but I keep getting errors: Unparseable =IF([Submission Deadline]@row - TODAY() < 15, "Red", "Green", IF([Application Deadline]@row - TODAY() < 15, "Red", "Green", IF([Booth Deadline]@row -…