-
Stumped!
Trying to calculate a % for where a particular column is filled in. We have various blanks (lining up with headings) that I need to involve in the calculation. Here's my formula: =ROUND((COUNTIF([Common Control - Client Comments]:[Common Control - Client Comments],<>"")-COUNTIF([Ctrl odr]:[Ctrl odr],""))/COUNTIF([Ctrl…
-
Upper case for first letter of the word
Hi Team, Can you please confirm how to update the first letter to upper case. I have a formula that extracts the first name and last name from email id. so I am getting "gaurav" from gaurav.chauhan#amplity.com. I wish to change "gaurav" to "Gaurav" Thanks, Gaurav
-
Multi-Select Column Formula to Add Values
Is there a way to add values to a multi-select column using a formula? I have several sheets that i want to switch from checkbox columns to a single multi-select column "Subscribed Calendars". It is VERY manual right now doing it by hand and will take a ton of time. I've tried using the "IF" formula, but it only adds the…
-
Formula to change cell values based on another sheet's column condition plus unique identifier
Hello, I'm looking to change a single cell value in sheet 1, based on the following criteria in sheet 2: All of column A where number = "1234" AND columns B, C, D = "Yes" Essentially, I need the actions from columns B, C, and D to have happened before changing the cell value in sheet 1, but it needs to have happened for…
-
Add a Search Option to a Form
I am in the process of learning SmartSheet and translating a simple access database into SmartSheet. So please excuse my ignorance. I am using some forms to update data in a sheet. I would like to add a search field to a form so that the user can open the form and call up the data from one of the Sheet's rows. Of course…
-
Pulling a Value based on Beginning and End Date.
I am having trouble figuring this one out. I have seen all the posts about using index and collect but have not been able to get any examples I have seen to work. I want the CSR row from one sheet to fill into a specific cell in another schedule based on the date. So, for instance, this week, the name "Nina would appear in…
-
Check a box if MOST RECENTLY MODIFIED, per Hotel
Pulling my hair out! Need to check the box of the row with the most-recently-modified entry, per hotel. Not the best data set for an example but below is a screenshot of my grid. Using this formula but getting INVALID results. =IF(AND(Hotel@row = Hotel@row, Modified:Modified = MAX(Modified@row)), 1, 0) Anyone? Anyone? :)
-
Why isn't my VLOOKUP Formula returning a match?
I've input a column formula to cross reference another sheet, and return the value in the 3rd column when there's a match. The formula is =VLOOKUP(Email@row, {Table with 3 data columns in the other sheet},3) The formula worked for the first row of data, but the second returns "#NO MATCH. I'm really confused at to why this…
-
All cell values if not same throws an error.
Hi Team, I have four summation cells wherein the value comes out same. In a different cell, am trying to write a formulae wherein if any of those sum values don't come out same, then it fives me a false error and from there I can create an auto reminder. Can you please help write this formulae.
-
How to get a formula to count data on 2 sheets
We have an "assignment queue" worksheet that counts number of tasks assigned to each of our users. The users get assigned when a form is submitted to another sheet - how can we get the formula that counts number of assignments to look at both current assignments and new cases coming in since they are on 2 sheets?