-
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?
-
Is there a way to optimize drop down menus?
hello i am trying to have certain values only show when someone chooses one value. here's an example: Entity 1 Entity 2 Entity 3 Now based on those three entity there would be a seperate drop down menu with 10 items: Item 1 item 2 item 3 item 4 Ext... But if i choose entity 1 then only item 2 and 7 show but if i choose…
-
Task Health Formula - Color Ball
In our project plans we have child level task health and then parent level task health in the same column, indicated by a color ball. Previously, we had separate formulas for each level, but I have been working with Pro Desk to implement a formula that will work for all levels and can be a column formula. We are so close…
-
Display date from different row in same sheet
I have a Smartsheet with employee names, email and hire date. Approximately every year employees are required to upload an updated resume, using a form to populate the sheet. On that new row created by the form, the hire date is blank because employees can't be counted on to remember the correct date. We want to use the…
-
Need help with a SUM/LEFT formula
I need a formula that will add the 1st number in different cells in a row. So in the below picture, there will be different numbers in these cells, with text behind it. At the end of the row I would like to add all these numbers together and get an overall score. Here is the SUM formula I have, just need to know how to…
