-
Multiple Countifs with Or statements
I need to create formula, where it will put a 1 if a person is assigned to an activity during a given time frame. What I'm looking to do is search for a name in Sheet B and see if it falls in a given time frame. The issue I'm having is that the name can be in any of the columns Tech1 to 6 in my second sheet. I am trying to…
-
Dynamic View - Unable to update
Hello- I have a team working with the dynamic view to do their work. In the view, they said that under the email fields that they are not able to override/change the email address that was put in from the original form. I cannot see anything that would keep them being able to and when I put a test example in, I don't have…
-
Formula/Function for drop-down menu items
Ok, so here is the scenario. I am trying if at all possible to calculate a total for some drop-down menu prices and produce a total for the items that are selected in the right-hand "Total" column. I'm new to Smartsheet and going in circles trying to find a solution if there is one. Here is a screenshot: Thank you in…
-
IF Statement for automatic checkbox
Hello. I have two columns "Gate Status" and "Gate Current (Mdays)". I'm trying to write a formula that does automatically adds a checkbox to "CurrentGateLate" column when the following happens. When "Gate Status" = "Gate 1" and "Gate Current (Mdays)" is greater than 10, then add checkbox. And....When "Gate Status" = "Gate…
-
Formula Help
I am trying to return a symbol with my IF formula, using the symbol "title" as the value. My formula keeps returning "unparseable" any advice??? its a zero to five star symbol based on a different cells value that changes with a form for rating. =IF([Average Rating]2<0.5, "Empty", IF([Average Rating]2<1.5, "One",…
-
Cross sheet reference form limited number of columns
Hi group, I am trying to use a formula with a cross sheet reference but when the cross sheet reference form opens i only see about 5 columns of the 50 columns on the reference sheet and the ones i need are not there. I cannot find out what i need to do. Can you help? Thanks, Judith
-
Multiple contacts update
Can we multi populate contact list looking into multiple values in a drop down. Example - if there are 2 departments in a multiple drop down list, can there respective contacts get updated in the contact cell
-
COUNTIFS box checked and End date 3 months from now
Hi, I am having trouble with counting how many projects, that have Global Report checked, are due to end within the next 3 months. I wrote the following formula, but it returns invalid operation, could someone please help me out? =COUNTIFS({ Global Report}, 1, { Project End}, AND({Project End} >= TODAY(90), {Project End}…
-
Tracking project's resources with formulas
Hello, My problem is that I’m trying to create a formula that would check if one worker (resource) has more than one project at the same time. I have used following formulas: Formula that checks if projects overlap: =IF(COUNTIFS([Finish date]:[Finish date]; >[Start date]@row; [Start date]:[Start date]; <[Finish date]@row)…
-
How do I change a cell value to a symbol
In the automation 'Change cell value', is there a reason that symbols are not included? I want to use the symbols, but base on the response from other team members. The responses are being asked from a Drop Down menu, but I cannot get the automation to then create symbols in another cell? Please send help :)