-
Delete row method returning a parsing error when it previously worked
Hello, This method was not giving me any issues prior to today. I'm using hte c# sdk. code: smartsheet.SheetResources.RowResources.DeleteRows(long sheetId, Sheet getSheet, true) returned error: NameValueType ▶$exception{"Unexpected character encountered while parsing value: <. Path '', line 0, position…
-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
IF formula
I want "In progress" to display if the check # field is blank or CCC Approved field is Yes, otherwise I want "Complete" to display. I've tried this formula but the syntax is wrong. =IF(ISBLANK([Check #]1), "In Progress", IF([CCC Approved?]1=YES, "In Progress", "Complete"))
-
#Unparseable Error When attempting to use IF function
Hello Everyone, I am trying to write an IF function to automatically change the value of a certain cell for certain conditions. For some reason I keep getting the #Unparseable error when I type out this formula. =IF((NETDAYS([Date Need By] 6, Today())) < 3, [At Risk], [In Progress]) I have attached a screenshot of the…
-
COUNTIFS Multiple Criteria and Checkbox - #INCORRECT ARGUMENT SET
I am having #INCORRECT ARGUMENT SET error message with this COUNTIFS. Please help. I am trying to Count Client Name column if both criteria are met. 1) Client Experience Manager = "value" 2) Terminated checkbox not CHECKED =COUNTIFS({Client Name}, {Client Experience Manager}, "Joe Smith", {Terminated Checkbox}, 0) Any help…
-
SharePoint ideas?
Greetings, I am a SharePoint admin for our company and would really like to know how others have integrated Smartsheet into their site. Right now we have an icon with a link to the page. It would be nice to have it go to a particular Smartsheet.
-
Processing Limitations: List of formulas in order by relative processing power required?
Hey Community! One of my first requests. I dug around and so far haven't found anything, but my apologies in advance if this has been addressed elsewhere. My company has been bouncing off sheet limitations for a bit now, yet none of our sheets are anywhere near 10,000 rows (I separate into logical volumes as often as…
-
Countif Query
Hi, I currently have the following formula which is used for counting how many jobs we intend to complete on a day: =COUNTIF({Realistic Completion Date 4}, {Realistic Completion Date 4} = TODAY()) This works fine, although there is a scenario where we often add things to the job, which is identified by a letter A in the…
-
Harvey Ball formula that reads across and produces cumulative
Hi All - I would like a formula that reads across vs vertically - here is my vertical one. I need the same thing but read about 10 columns status to then come up with an overall status meaning if there is 1 red, 7 yellow and 2 green then the overall cumulative status is red (lowest common denominator) Vertical Formula:…
-
Global Updates and using VLookup formula in it.
Hello all, I wanted to know is it possible for us to do find and replace in global update and change a Vlookup formula or to introduce a new Vlookup formula. I am trying to do that and i am not successful in accomplishing that. Please some suggestions.