-
Why does this formula not work today?
=DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) - WEEKDAY(TODAY())) It is the Weekday part of the formula that is stopping it from running. Using INT and VALUE and whatever else I can think of doesn't work. @Genevieve P
-
Parent function to auto-populate cells
Hi everyone, Wondering if someone could help me with a formula to auto-label cells. I'm creating a project tracker for my team on Smartsheet and have automation set up for approval process, and also so completed tasks are moved to a new sheet. The problem is, on both instances, the row itself might not contain all…
-
Formula to paste values generated by function
I'm trying to figure out an automatic way to run a function in a cell, and have that function paste the value, and only the value, to that cell. I don't want the formula to continue to exist within the cell. Similar to if I copied the cells post calculation, and did a paste-special of only the values. For example, =5+3…
-
IF formula for RYG balls
Hi I am trying to make a formula that states: If it is 14 days past the TBF date field, and the Reported date field is blank, make the ball Red. If it is 7 days past the TBF date field, and the Reported date field is blank, make the ball Yellow. If the Reported date field is NOT blank, make the ball Green. Nothing I try…
-
Count days between start date and today
I want to count the days between the start date and today if the end date is blank.
-
Average formula
I am sure this is rather obvious, however I am not seeing where my mistake is. All I am trying to do is return the average cost of a product cost column but I need to not include any $0.00 dollar amounts that are populating (which will happen when there is no inventory at the moment). Can someone please advise where my…
-
COUNTIF Column Totals - Would like to Exclude Two Cells
We have a form connected to our sheet. Form submissions are added to the top. Each column asks a question where the submitter can choose one of three answers: Yes, No, or Don’t Know The Yes, No, Don’t Know totals are at the bottom of the sheet using the COUNTIF formula. We originally set up the formula to include the rows…
-
Is there an alternative for WORKDAY.INTL in Smartsheets?
Hi, I have a formula on excel that uses WORKDAY.INTL and it doesn't work in Smartsheets. I have made the formula so it only produces dates that are on a Tuesday, Wednesday and a Thursday. Is there another way to do this? Thanks, Liam
-
Need help with an "IF", "CONTAINS" and "OR" formula
Hello everyone First, thanks for your help :) I'm trying to make a formula. I have a cell (cell#1) that has 4 values in it (" one", "two", "three", "four"). I'm looking for a formula that would work like this: If cell #1 contains "one" or "two", then cell #1 =0. Otherwise, calculate the number of values in cell #1. Could…
-
Is it possible to count if a cell changes?
Hello! I am trying to calculate the amount of times a cell dropdown is changed per day. Is this even possible or would it need some magic workaround? In any given day the "current stage" column changes possibly many times. An example question would be: how many times did a cells in "current stage" column change from "Art…