-
Comparing dates IF/AND
Hi, I am trying to create a formula for: If Date1 is less than 2/29/2022, then cost for the month is Feb2022 at row value. If Date1 is greater than 2/29/2022 and less than 3/31/2022, then cost for the month is Mar2022 at row value. Formula below isn't working: any help on what I am doing incorrectly is much appreciated.โฆ
-
Formula Help Needed to Remove 0 From Results
Hello Smartsheet Community! I need some help to better understand what is happening. Why are only some of my results generating a leading 0 in front of my text? I have a multi-select column with a variety of text values for more than 20 groups. In the same sheet, but in different columns, I have written out a formula toโฆ
-
Sum of total pend per Quarter
What's wrong with Formula?
-
Formatting Charts
Hi all, I am trying to make a chart that references a report, and I have been successful in capturing the avg, and count values of groups I made inside the report. Where I am having trouble, is that I want to change the labels of the Legend. The legend pulls the name of the column it is referencing, however it isโฆ
-
How does "in the next x days" calculate days?
I am working on a schedule for multiple employees and I would like for the different dates to be highlighted. How does the "in the next xx days" function work? My conditional formating is recognizing today (6/27) & 6/28 as both being in the next 1 days. Thanks for your help!
-
Prepopulate information in forms
Hello everyone, I am trying to create a Smartsheet form that would automatically populate information when a user fills in a form and leaves certain columns blank. When a user leaves certain columns blank, it indicates that nothing has changed for that specific project so far. For example, if there are 10 unique projects,โฆ
-
Split text to multiple columns
Hello! My team is using the JIRA connector to pull ticket info from JIRA to Smartsheet. In the JIRA description field, the team has a template that contains several key pieces of information that I would like to separate into multiple columns. Basically, I would like the ability to pull everything to the right of the : forโฆ
-
Countifs formula for checkbox column has suddenly stopped working
Hello All, My Countifs formula that counted when a box was checked in one of the columns has stopped working, giving me an invalid value error. I'm not sure if it was a recent update or what, but it has suddenly stopped working. The Countif formula checks if the value in the checkbox column is checked: =COUNTIFS([H1]:[H1],โฆ
-
Averageif for a goal of 90%
Hello, I am trying to get my averages for monthly totals of projects. The goal is 90% but i am not sure how to word the formula to take that into consideration when calculating the average. Any insight is greatly appreciated.
-
Group Report by Month and show current month first.
Hi there Community, I'm trying to pull a report that shows my due dates for all my projects. I want to group the due dates by month. I created a formula that pulls the month name from the due date. If I have a project that's due 6/15/22 and another one due 6/27/22, the formula will pull 06 JUNE for both of them. I thenโฆ