-
Adding attachment via the API
Hey, I'm using the API to create a sheet and I want to attach a pdf to each row. It looks like I would need to first create the row, then get its rowId before I can add an attachment to it. is there a way to include the attachment as part part of the row creation? Basically, is the rowId mandatory, or is there a way around…
-
API write over a sheet
Hey, I want to feed my sight/report with a sheet refreshed once a day, however I'm not able to find a way to write over a sheet so that the sheetId remains the same. There are too many possible changes to use updateRows, as some of the rows could be removed and/or added as well as updated. Is there a way to write over…
-
Hiding a column using conditional formatting feature
I am in the process of creating a survey for my work place. The survey questions are all yes/no questions. These questions take form of their own individual columns on the spreadsheet. Some of the questions have nested follow-up questions, with responses being children to a primary parent question. For example: " Do you…
-
date calculation
I want to calculate the actual number of workdays from a scheduled start date and scheduled finish date but i keep getting the wrong answer. a project started May 9, 2016 and is scheduled to complete on June 16, 2016. My date calculation says that's 27 work days which is incorrect. the formula i used is…
-
New to Formulas - Need help with Text Answers
I have tried to create a formula using three options being 1. Does not meet Insurance Standards, 2. Meet Insurance Standards 3. Exceeds Insurance Standards for a particular series of questions. If you choose "Does not Meet Insurance Standards" then then next column Score will also populate 1 and the cell will highlight…
-
Missing smartsheet template
When Smartsheets launched thier new card view, they also had several templates they provided. I downloaded one that was a ticketing system that tracked average submissions per day, etc. I cannot locate it now. It had some fairly complex formulas that made the tracking work. I have attached a screenshot. Anyone notice this…
-
Ticket Tracker Notifications
We would like to have Ticket Tracker send an email to the person who submitted the ticket to us, when that ticket has been "resolved". I do not want everyone to get the notice, only this one person. Has anyone been able to do this? I can set the Alerts but cannot narrow it down to just the one person. I can do a reminder,…
-
Setting up a Point of sale Sheet
Good afternoon, I was thinking of setting up a POS/point of sale sheet on excel. I googled it and found instructions on how to do it. But the person that was nice enough to post the information wrote it assuming that everyone knows how to enter Macros etc.. Then it came to mind that I should check here. I did speak with…
-
Date Driven row roll off
We keep a list of Completed tasks. Based on the date in the Work_Ended column, I would like to autmomatically move rows > 90 days old onto another sheet, which we'll call Completed Archive. Is there any way to automate this process? Thank you!
-
How to populate % Complete from another Text/Number column that has a formula
Hi, I'm trying to calculate and populate % Complete automatically using check boxes fields. For example I have 3 check boxes for 3 main activities per record. So I created I new field Count Check Text/Number field where I check if the first check box is checked the new count is 33%, if the second is checked with the first…
