-
Method to update field automatically (based on other field updates)
I was looking to see if there was a way to make an update to a field based on the status of other fields in the sheet. In my example I have a review process that sends multiple emails at once for review and approval. The reviewers each have a field that the indicate approved or rejected in. Once all of them have approved I…
-
Quote Tracker Project Template
Looking for a project template for tracking quotes from multiple suppliers for a long list of parts.
-
Rows
Has anyone had problems with rows moving radomly? Any ideas on how to prevent this?
-
Custom Views
Hi everybody, this is probably not a new one, but I've not been able to immediately identify the right thread - therefore let's try again: We've started a new sheet with some intense collaboration, and everybody has his preferred view in the meaning of what to collapse and what to extend (preferences as well change over…
-
HELP! RYB Color Change Based on Dates
Hello everyone, I am currently using this: =IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 >= Completion4, "Green", IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 < Completion4, "Red")))) Which is working but I try to add this: IF(ISBLANK(Completion3), IF(NOT(ISBLANK(Supervisor4)), "Yellow" And it doesn't work, I'm…
-
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…
