-
When checked box, don't count line in total Formula
Hi there i have an expenses sheet. Once the expense has been submitted the manager approves these expenses, accounts then can log in and check the expenses are authorised prior to repaying the staff member. Is there anyway when the processed box is checked it removes the line from what's due in the totals? Thanks again
-
Return value as per date
I need to have the all the return value from column 209 if the End Date goes beyond a certain date at end of month like Nov 30 ,2021. The return value is on a different sheet. What is the best approach. Thanks
-
VlookUp
Hi all, I have an issue that I am hoping one of you can come up with a solution. I have a confidential HR register, I would like to link Sheet A to it just extracting names and department, that will update as staff leave and join. are there any ideas ( My Manager for obvious reasons doesn't want anyone but himself…
-
Right and Left Function for words within a cell
Hi, Any way to copy the 3rd word from the Right in [Address Column]@row? I have an Address column, I want to copy the City (3rd word from the end) into another column. [Address Column] Includes: Street, City, State (2 Values I.e. NY), Zip Code (all in 1 cell). Thank you!
-
Formula works in sheet but not via API
Hi I struggle with smartsheet api. When i try to add column to a projet i have this error : ERROR MESSAGE: Error add column: {"result": {"code": 1310, "errorCode": 1310, "message": "Invalid column formula syntax, see help article https://help.smartsheet.com/articles/2481944?ss_lc=fr_FR&source=apphelpicon for more…
-
Formula/Automation for copying Finish date to a new date column
Scenario - There is no existing finish date in finish date column. I add a finish date. There is another date column present. Inquiry - is there a formula/automation to copy that finish date to the other date column only once and never copy it again?
-
Can Automation Workflow update a column with information that is populated in another column
We have a column called "Case (Internal Only)" that people clear out when the Status becomes Cancelled. I've tried to get the users to stop doing this but it keeps happening. I'd like to have the information currently populated in this column added to a new column that will be locked and hidden, preventing users from…
-
AVG(COUNTIF) question
I am not a programmer and am trying to build a dashboard, but I need to figure out how to do a an AVG calculation. Can someone help me with the formula? I need to calculate the Average % Complete grouped by primary Assignment. For Instance: =AVG(% Complete) where Primary Assignment = "Business" =AVG(% Complete) Where…
-
Adding IFERROR to another IF Statement
I am trying to add an IF ERROR statement to the formula below so that it is left blank instead of saying "#invalid data type". I'm struggling to make it work and would appreciate any help. =IF(MONTH([Launch Date]@row) <= 3, "Q1 ", IF(MONTH([Launch Date]@row) <= 6, "Q2 ", IF(MONTH([Launch Date]@row) <= 9, "Q3 ", "Q4 "))) +…
-
Distinct and Collect with Arrays
I am looking for the syntax for a COUNT, DISTINCT, COLLECT formula that will count number of distinct values in an array of cells, but only in rows that have a certain value in another column. For example: Active Status | Required1 | Required2 | Required3 A | PSY 101 | PSY 102 | ACC 233 I | BUS 212 | MHT 232 | ACC 314 A |…