-
Formula Help
Good morning Community, Please could somebody help me figure this out. When the schedule date = today, the status is turning red, whereas it should be yellow. Any date past today should be red only. I hope that makes sense! =IF([Scheduled Date]3 = "", "", IF([Date Completed]3 <> "", "Green", IF([Scheduled Date]3 <=…
-
I want to be able to achieve a line graph overlaying 2 types of events " Incidents" & Planned Event
I want to be able to achieve a line graph overlaying 2 types of events " Incidents" & "Planned Events" and plot Dates down here. The way I have it setup and the only way I can figure it out is to have the "incidents" I am counting by Month for the X axis. But it is a range of incidents that span 2022 and 2023 here and I…
-
Help with Sumifs Formula
Hello, I am trying to sum totals in one column based on criteria in three other columns. Sum of totals in one cell based on the approval status, classification of the expense in the other columns. =SUMIFS(Total Projected Cost:Total Projected Cost,Classification of Request:Classification of Request,"T&E",Approval…
-
Update formula wizard when used in sheet summary
This is because the wizard only offers 'Reference another sheet' when this is slightly illogical as you are in sheet summary ie to summarise the sheet you are in. You then cant click on the column header to add the range to the formula when using sheet summary without an error. The way to add the range is to scroll down…
-
Cross Sheet Reference Limit
Hi guys, Can anyone tell me if the same referenced field is used in more than one formula, is the reference counted as 1? I've mixed out my references and wondered if there's a way to reduce the number of unique connections.
-
Replace Cell with the Value of a formula
A common workflow for me while preparing data, is to use a formula to setup some cells and then to copy and paste the Values back into the same cells. Excel allows you to copy, but to paste just the values. (NOT the formulas). Can this be done in smartsheet?
-
Is it possible to update a contact list column based on a value in another cell?
Is it possible to update a contact list column based on a value in another cell using a formula? I am creating an assigned to contact list column with an end goal in mind of setting up a dynamic view based on setup specialist (my understanding is you can only set a user view based on a contact column). As you can see - I…
-
I want to count the number of times a contact appears in a column, how do I do that?
So, I started with =COUNTIF(Name:Name), FIND("John Smith", @cell) > 0) this produced #unparseable. My ultimate goal is to have a dashboard that will display a pie chart with total number of leads per person. Thanks for any help!
-
Making Negative Numbers Display as Zero
I am trying to calculate the number of working days between the due date and date received on a contract deliverable. The formula works great when the contract deliverable is received on time or after the due date. The problem I am having is if the contractor submits the deliverable early (prior to its due date) it is…
-
Is there a way to write a formula to uncheck the box in one column IF another column has a checkmark
I am wondering if there is a simple formula that will uncheck a box in one column if a second column is checked. I am sure it is a really easy formula but I am drawing a blank. Thanks.
