-
Drag fill across colomns
I have a sheet with 180 columns, each with a "add sum" *=sum([column name]:[column name]*. I am trying to "drag fill" the add sum across all 180 columns - but the formula does not adjust to the [column name]...any other way of doing this than typing the formula for each column? TY
-
Finding a formula
I have a formula counting the last 8 numbers in a row. I have hovered over the cell and can't find the formula to copy it to another line what am I doing wrong?
-
Using formula - Pick first day of the week
For example, today is 11/15, and first of the day (Monday) of this week is 11/13. How can I pick up 11/13? Thanks for your advice!
-
Need a way to calculate hours and minutes
We are using the hours and minutes duration option for our projects and need a way to calculate the stop time based on the duration. We enter the duration and Start Time and want Smartsheet to calculate the stop time (currently we have to enter it manually and there is definitely margin for error... not to mention time…
-
Project Management - IF(OR(AND())) - Formula Help
I've been working on this for some time and just can't seem to get it to work the way I need it to. I am attempting to build one sheet that will allow me to track the status of all the projects in my section, while also tracking the progress of tasks within each project, for both current and historical projects. I have…
-
Formula to check if cell contains a value from a range of cells
For example, the text in column 4 row 2 is "xxxxx_email address=test@test.com" * The text in column 2 row 11 is "google@google.com" * The text in column 3 row 11 is "1" * The text in column 2 row 12 is "test@test.com" * The text in column 3 row 12 is "2" * The text in column 2 row 13 is "smartsheet@smartsheet.com" * The…
-
Formula needed
I am trying to set up a formula that will subtract from a given value, each time that item is found. I have a form that my team will be using to enter data (item) and how much they found (subtract from value). In turn, I need to have a running total of what is still not reported for each item.
-
Formula to get data from current week only by day of the week.
I have a worksheet with case information and who these cases are assigned to. I am trying to add columns that will total the cases from each day of the current week. ex. columns with a total count for mondays cases, tuesdays cases etc. thru friday. This worksheet has data for the whole month and all I need is the current…
-
Regular Expressions (RegEx) with FIND function
Hi Team, I'm guessing that SmartSheet doesn't support regex in formulas as I get an #UNPARSEABLE error when I try it but I thought I'd better post the question here before I make that assumption. I have the following text in my "Subject" column: [1751] - Guide Posts With the formula: =MID(Subject1, FIND("[", Subject1) + 1,…
-
Filtering out data from an equation
Hello, Is there a way to filter out specific data items from an equation? Specifically I am creating a sumifs formula and I would like to be able to filter out fiscal year data without making it a condition of the formula, that way we wont have to change the formula every year. I have a column that shows the fiscal year as…
