-
Help with Auto Number column formula
Hello, I've pretty new with Smartsheets and most of the time I try to use the examples from other posts that I have seen others put up in order to solve most of the problems that I have. Unfortunately, I cant seem to get this problem to work. I have 3 sheets, Source, Helper, and Destination sheets for an Onboarding project…
-
Vacation Days Formula - calculating half days
Hi, I am trying to incorporate 0.5 days of annual leave into my vacation tracker. I have the forumla =NETWORKDAYS([Start Date]@row, [End Date]@row, {Bank Holiday Lookp}) to calculate overall number of days out (minus public holidays). From this total I then want to include any 0.5 days from this when 'half day requested'…
-
"date created" and use "date closed" to see how many days the case was open?
Hellow I'm asking for help with a Smartsheet's formula. I want to take "date created" and use "date closed" to see how many days a case is open. How do I write the formula for that? I'm placing this formula in a calc sheet thats pulling data from the data sheet. I appreciate any assistance you can provide. Have a great day!
-
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…
