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…
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.
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…
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…
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.
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…
Hi, Im curious about what the community has built or dreamt of building for holiday season needs? templates for sending /automating holiday cards? gift list and shopping? menu/party planning? santa list etc? Im interested in ideas to spread some help and joy via smartsheet this pending season.
I have a sheet with the name of a business and the corresponding contact emails for each business. In another sheet, I would like for the name of the contact to populate when the corresponding business is entered on the same row. here's what I've tried... =IF([Name of Business]@row = {Recall Business Contacts final Range…
Hi there! As an event organizer, I want to automatically update my schedule in smartsheet when a session takes longer than expected. Column 1: Start Time (HH:MM) Column 2: End Time (HH:MM) Column 3: duration in minutes Column 4: new start time (HH:MM) how can I arrange a formula so that once entering a new start time in…