-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Can you use the TIME function to calculate the difference i.e. duration between values in 2 columns?
Hello, I've previously used the many pointers and guidance on the forums for coming up with solutions that help calculate time and duration between columns using a range of different helper columns.. I've never used the TIME function before, but I'm hoping I can use this to try and save having to add multiple helper…
-
How to populate duplicate numbers into sheet?
Hello, I have one main sheet that tracks all incoming DRR #'s and every row has a couple of names in it. I want to build another sheet that tracks names based on the DRR # but want it to populate in different rows, like below. So two people are on 0001 while in the main sheet that would only be one row
-
Modify scale on an axis of a graph
Good Day t´s possisble modify scale in an axis of a graph exist? for example, I have a graph, in the vertical axis the scale it´s 0.5 to 0.5, but i want that scale will be 1 to 1, it´s possible? regards
-
Smartsheet dashboard widget line graph: y axis min/max values
Hi there, is there a way to set min/max values on the y axis? Below is the sample data set and 2 line graphs with differing y axis min/max values. I'd love to set them to be the same for all graphs.
-
Charting a multi-select column using a metrics helper sheet.
I have a sheet with a multi-select column (Law Firms) and I wish to show a chart in my dashboard that displays a count of the unique firms in that column. I created a separate metrics sheet with one column (Law Firm Names) containing each unique value contained in the multi-select column. In my other column, I'm using a…
-
Countifs for if either column is checked
I have two checkbox columns and need to get a count of how many rows have either or both of the check boxes checked. I am struggling on how the formula to accomplish this is the sheet summary. Below is my current equation for getting the count of one of the columns, I am able to do this for both to get a count for each…
-
Formular Stripped from cell when the row moved into different sheet
Hello, I use simple formular to assign Due date =WORKDAY (Start Date, #of days) to add. I love it- Simply Works! Attached image. Now, when this row met workflow automation criteria, and then move into different sheet as completed, the formular no longer display. Only show Due date value. It this stripping formula normal? I…
-
My IF statement isn't importing from excel and can't figure out why
I have what I think is a fairly simple nested if statement that isn't importing into Smartsheet, it just shows blank and I can't figure out the issue. The excel formula is: =IF(ISNUMBER(C2), IF(AND(ISBLANK(X2), ISBLANK(Y2)), TODAY() - C2 + 1, IF(AND(ISNUMBER(X2), ISBLANK(Y2)), X2 - C2 + 1, IF(AND(ISNUMBER(X2),…
-
Form not auto populating fields if one column cell contains a comma
I'm using a form that when triggered, populates several fields from a source sheet then posts to a another sheet. I've noticed that if the column titled "Description" has a comma in the text of a cell, such as image 1 below, then the form will not auto populate all of the fields that I want. It will also stop populating…
-
Countifs off by one
I am trying to get a count for a date range, but am getting a number that is one less compared to the filter. Current Tuesday Formula: =IFERROR(TODAY() + (3 - WEEKDAY(TODAY())) - IF(OR(WEEKDAY(TODAY()) = 1, WEEKDAY(TODAY()) = 2), 7, 0), "") Previous Tuesday Formula: =IFERROR(TODAY() - 7 + (3 - WEEKDAY(TODAY() - 7)) -…
