-
5x5 Risk management formula
Can anyone figure out what's missing in this formula to set a rating from a 5x5 risk matrix. I copied the format from the risk assessment matrix template set that is a 4x3 matrix and modified. =IF(AND(OR(Likelihood5 = "Rare", Likelihood5 = "Unlikely", Likelihood5 = "Possible", Likelihood5 = "Likely"), Consequence5 =…
-
Is it possible to have a report that is editable by people who dont have access to the source sheet?
Within the company I work for we have a source sheet with all our projects in. We need to be able to enable external (sub contractors) people to sign a report which auto fills information into the source sheet. (check boxes) This is so we have an audit history of them accepting projects. However, we not not want them to be…
-
Tracking date when a drop down value is selected
I'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doing is tracking when the drop down items are changed. I thought of using an IF statement where if "design" is selected, then…
-
Gathering data from 1000 sheets
Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to every corresponding line Use that number for further calculations (which is not a…
-
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.
-
Formula cross referencing sheet via template
Hello! I have a workflow created using Zapier so that when a new row is added to my master project sheet via a form entry it will update the first row in a template sheet and create a new project sheet from that sample sheet. This all works great with the exception I have one formula that uses a vlookup to tell the status…
-
Notification with Attachments
Hi there, I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true? If so, do you know of any good apps/software to automate that process? I have looked into…
-
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.
-
Smartsheet API Delete Row Function Error
Hi, When I run a code to delete multiple columns in a sheet >500. It run successfully once, the second try gave an error : Response: { status: 414 Request-URI Too Large content: { << text/html; charset=iso-8859-1 content type suppressed >> } JSONDecodeError: Expecting value: line 1 column 1 (char 0) The code below reads a…