-
If And Formula Help
Hi I am a new user of smartsheet. I need help on why this excel formual will not work. I get #UNPARSEABLE =IF(([Total Billed]40)<10000,0, IF(AND(([Total Billed]40)>=10000,([Total Billed]40)<20000),([GP Amount]40*5%, IF(AND(([Total Billed]40)>=20000,([Total Billed]40)<30000),([GP Amount]40*10%, IF(AND(([Total…
-
Downloading attachments through API with URLs fails
When requesting to download an object, I get a "timing limited" URL of the form: https://s3.amazonaws.com/SmartsheetB1/*******?response-content-disposition=attachment;filename="*************************.pdf";filename*=UTF-8''*************************.pdf&Signature=*********=&Expires=********&AWSAccessKeyId=***************…
-
Automatically add tasks to a web form populated row
Hi, I am fairly new to smartsheet and wanted to know if it was possible to automatically add a set list of tasks/ indented rows to a row that had been added via web form? I review sets of data that are submitted by multiple business unit and partner companies. The form this takes in always the same, and we have a set…
-
Cell Deletes When Highlighted
If a cell is selected, it automatically clears itself if nothing is typed or clicked within 5 seconds. Can be infuriating when trying to modify a smartsheet.] Happens in Windows Chrome and Internet Explorer.
-
Formula Help with NA
I need help with a formula. I have 3 date columns. If there's a date in datecol1, and a date in datecol2, and either a date or NA in datecol3, then enter 1 in col 4. I am not a programmer, but can usually figure it out. Not this time! This is what is in col 4 cell, but I get Unparseable. =IF(ISDATE([datecol1]7),…
-
Auto Date updating a published report of Events List
We have an a Smartsheet of Events - tradeshows etc that we will be participating in. While initially developed for internal sharing, I have added a "publish" checkmark column, with those items checked being part of a Report, which I then Publish to our public website. I would like to include a formula in the checkmark…
-
One Click Task Completion
Hi All, In Project we invariably have different variants of: - percent complete - Task Status - Completion Date - etc What I am looking for is a way where say I tick a "Complete" checkbox and: - percent complete goes to 100% - Task status goes to complete - completion date is today - etc
-
updates
Is there a way to send multiple sheets in one email?
-
The Power of the SUMIFS Function
When I discovered the SUMIFS statement recently it solved a problem that had made me keep things like the project timesheets for our company in a very rigid format that basically listed all projects and functions (types of work) that could be charged to. I had wanted to let people select the project they were working on…
-
Daily Calendar- managing executive customer appointments
Team, I am a sales manager and often i have exectutives that come in from out of town to visit customers. Currently I create a calendar in Word that shows the executives availability for the days they are in town and peridocally i update the calanaer and email it to my team of sales people so they know the executives…
