-
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…
-
Autocomplete date range
Hi All, This is likely something quite straight forward that I'm over looking, but hoping someone may be able to advise - Still relativly new to smartsheets. I have a smartsheet, in which each row reports based on week numbers, such as the below formula. =COUNTIFS({Enquiry Tracker (V1) Range 4}, <=DATE(2020, 9, 6),…
-
Mail Merge with Form
Hi all, I was searching on the Smartsheet community, but i could not find the best solution for my issue. Basically, in my company, everytime that a production finishes, i receive via e-mail the test results for the specific product. With those results, later on, i must issue a document to the customer with those same…
-
Dashboard automatic updates
Hello, I am looking for a way to send a weekly message to a group of shared users to view the team's portfolio dashboard. Currently I have a scheduled report that is sent weekly, I want to do the same with the dashboard. Thanks Michelle
-
21 CFR 11 Compliance
I work in medical devices, and I have been trying to figure out whether or not Smartsheet meets FDA 21 CFR 11 requirements? Because I would like to use Smartsheet for our logsheets. Does anyone know whether or now Smartsheet meets FDA 21 CFR 11 and how? Thanks!
