-
Formula assistance
Hi, I currently have a sheet set up where I am calculating the total revenue generated for all the tasks listed underneath the main header using the =SUM(CHILDREN()) formula. All the tasks listed underneath the header in the status column is being classified as awarded, cancelled, pending and unsuccessful as shown in the…
-
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…