-
Create cell reference based upon horizontal axis position
Is there a way to create a cell reference based upon a horizontal axis? For example, for a given column, I want it to always represent the cell directly to its left. For this example scenario, a new column will be added for every date and the new results will be entered into that column - Since the new date column will…
-
Multiple Sheets & Formula Updates
I am using Smart Sheets for Paid Search requests. So, when an AE submits a request for their client, we ask them for specific URLs to be entered. In the sheet where they enter in their URLs (via an Update Request), there are some formulas (vlookups) that we use. For the most part, those work fine, but there are times when…
-
Inventory Status: Reordered (How do I do it?)
Hello, I am developing an inventory reorder system and I need the status of the line item to show "Reordered" when the check box is checked under "Order Status" I recognize that there are multiple true statements within my formula so how can I show "Reordered" while the stock quantity is below the ROP? I have been trying…
-
URL Query string did not move with "Save as New" How to remedy?
I used a test workspace to create 2 data base sheets. One to hold existing info and one to hold newly created info based on existing. Users create this new data by clicking a URL to get to a form. I created a form and appended a query string to the form URL such that when a person clicks the URL, information from the URL…
-
Index/Match
I have a smartsheet that has a column for "State" and then a column for "Territory". How do I write a function that if a row within column "State" equals say "TX" than the column for "Territory" within the same row = "West". I would need to do this for all states broken into 4 or 5 territories.
-
Need Formula: "Is this person listed again in the next week?"
I'm trying to figure out how to build a formula with this logic. When a person is listed on a row with start and end dates, are they listed again for an upcoming event in the next week? Is it possible to create a formula that gives a yes/no answer. Or gives a count of how many times a person is listed in the next week? Or…
-
Synchronizing data from Microsoft excel into an existing worksheet in smartsheet
Hi everyone, i recently uploaded a file from excel and linked it to an existing worksheet in smart sheet. The file in excel is updated every week. Is there a way i can synchronize the file with smart sheet without having to upload the file again every week.
-
PDFs in proofing tool look strange now
Hello, the PDFs in my proofing tool column look strange today. The fonts are messed up and the pdfs are now barely legible. I see that the proofing tool possibly had an update last night, since we can now use squares and arrows (which is a totally awesome update that will be very helpful!). Is there a way to fix the pdfs…
-
How to Combine Multiple Formula for Matrix Table
Hi All, As we know, not all formula can be used in Smartsheet. Need help on combining "IF" "OR" "INDEX" & "MATCH formula. Currently we have a risk rating matrix where it depends on user selection on column "Consequences" & "Likelihood". Formula I apply in excel are:…
-
What's wrong with my formula?
I know the answer has to be something simple, but I am just not finding the answer. If the Favorites column has a check mark, then populate (the cell containing the formula) with the Initiative Project Name. Maybe I'm not using the right function? 🤔 It seems logical to me, IF this row has a check, enter this data from the…