-
I want to add an "OR"statement
-
Auto Assign Contact based on number of Open Tasks
Any help would be great. I have a form that dumps information into my sheet and would like to auto assign the task to a person/contact when it comes in. The Assignment is on a rolling basis. For example I have 4 people and as the work comes in it gets assigned to each one then starts again at the top of the list. Has…
-
adding email adress/people into contact group (issue)
Hello everyone. I often create contact group. I used to be able to put any email adress/people I wanted into these contact groups...until today. I created new group today, and for some reason, I sometimes get a message saying "you cannot add this user to this group". This message seems to happen only for specific people…
-
Nested If/And but need and And/Or
I am trying to have the Opportunity Status ball automatically turn green when the four columns to the right are Green OR Gray. I can get the formula to work with just "Green", but when I try to put the OR "Gray" into the formula, it results in a yellow ball or unparseable. =IF(AND([Commercial Business Case Completed]1 =…
-
How to pick the latest date from Table 1 and enter it to the cell of Table 2?
Table 1 is a list of products that contains among others columns Trade Name, Country, Crop and Last Modified (Auto). Within the rows, one trade name can refer to different countries or crops. In Table 2 there are only Trade Name and Date columns. I need to choose the latest date from the rows of Table 1 referred to the…
-
Help: #INCORRECT ARGUMENT SET
Trying to figure why this isn't working...the first two formulas seems to work but adding the third gives me the #INCORRECT error...Please let me know what I did wrong? =IF(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row), "", IF(ISBLANK([2nd PRODUCT OWNER APPROVAL]@row), "", IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "APPROVED",…
-
Terminating a formula once criteria met
Hi! I am working on a sheet that has a basic if formula to populate the Red, Yellow, Green symbols. I want to be able to have the cell not change or have the formula run once the line is shown as "Red." My formula is =IF(AND([Scheduled End Date]1 < TODAY(), Status1 <> "Closed"), "Red", IF([Scheduled End Date]1 <> [Actual…
-
How can I use the SUM function in a column, but only add/account for numbers that are in child rows?
Is there a formula that I could use to SUM numbers in a column, but NOT accounting for values that are in parent rows? The formula would go on a sheet summary; the reason not to account for values in parent rows, is to avoid duplication, since they are a reflection of the information in their child rows. Thank you!
-
Project Management: Automating Timelines Across Multiple Projects/Sheets
Before I go into specifics, maybe the simplest form of my question is: can I somehow mimic the functionality of LiquidPlanner's "Smart Schedules" in Smartsheet? (Just to clarify, my company doesn't have LiquidPlanner nor does it plan to, it's just the only product I've heard of that has this functionality out of the box.)…
-
Automation - Changing data on feeder sheet will update recipient sheet too?
Hi there, I was trying out the automation function to link important dates from several project plans to one central location that will act as a calendar. Automation is: If "Add to calendar" = checked, copy row to calendar sheet. The premise works well, but in cases where the date changes on the primary sheet, this does…
