-
Is the a formulas that counts cells? Sheet limit question
Hi, I was wondering if there a formula that can count the number of cells in a sheet? I'm trying to make sure we don't go over Smartsheet limits. Also do the sheet limits count all cells in a row or only those cell with information in them? Thank you Kim
-
Trying to find total spent by month
I am trying to find a formula for my calculations sheet to show how much was spent during each month. Below is a snippet of the Maintenance Tracking Sheet that my team uses to track each invoice (this will be the reference sheet). I have tried numerous formulas and none have worked. For example, how much was spent if the…
-
Can you trigger an auto-number column to generate?
Hello, I want to have Smartsheet create project numbers following a specific format, but generate the number when I click a checkbox in another column. I cannot figure out how to make this work? Here's what I've done so far: Column PN Auto is an auto-number column with prefix 'TD-' and numbers starting from 1700. I do not…
-
Rounding Formula
Hi, I'd like to round the result of the division in this formula to the nearest whole number. =IF([Column1]@row = "Text1", [Column2]@row, IF([Column2]@row = "n/a", "n/a", [Column2]@row / 2)) I tried placing MROUNDright before the last section of the formula like this, but I got the error "INCORRECT" =IF([Column1]@row =…
-
Row # on Another Sheet
Hey! First thanks in advance for looking. Is it possible to get the row # on another sheet? I want to know the Row # for New: Release Update Sheet. New: Release Update Sheet Release (would require Is Parent to be checked) Row ID (Auto Number) Release List (This sheet is where the formula would go) Releases Auto (Auto…
-
Cost Calculation with Multi-Select Dropdowns
I have an intake sheet for samples received for testing in my lab. I originally set up a multi-select drop down column where all requested tests could be selected. Originally the sheet was set up to track studies submitted over time, but now management wants to incorporate cost into my dashboards. I'm trying to figure out…
-
Find FedEx Number with the Latest Date
I have duplicate DEVICE NAMEs with associated FedEx numbers and different RECEIVED DATEs in the target Sheet above. I have another sheet (my Source Sheet) that has a list of corresponding Device names that I need to match against the Device Name in the Target Sheet. If a match, find the latest RECEIVED DATE associated with…
-
I need help to sum all data by month & owner in one column for a pivot table for our dashboard.
This is our raw data sheet. For the pivot table chart I need to sum the location total for each owner. by month into one single column in my pivot table sheet. The pivot table sheet will then display on our dashboard. And the pivot table is not an option for us right this moment. Here is our pivot table chart so you have a…
-
Import a formula via workflow
I was playing around with the workflow and almost got a formula imported However after the formula got added it leaves a ' mark before the formula , that must be manually be removed for it to actually take effect Kind Regards Brandon Austin
-
Retrieving Ancestor (date) value from multi-level parent-child rows
Hi All, I used the following formula to retrieve ancestor (first parent) date value of the multi-level parent-child rows for each row. =LEFT(INDEX(JOIN(ANCESTORS(Date@row), ","), 1), 8) The issue that I'm facing is the return value being "TEXT" despite having "DATE" column type. Since I have to use this return value in…
