-
Does SmartSheet have an equivalent to Excel's "Name Manager" and "LAMBDA"?
I need a way to label a specific set of data or create a custom function that can be used in cross-worksheet formulas. Related to another query of mine, I need to take a list, give it a specific name, and reference it without having to navigate to the source sheet every time it's needed. For example, let's say I have a…
-
Copy sheets and references
Hi Everyone! Let's say we have one folder [A] with 3 sheets that have references. If I want to make a copy of this folder (Folder B), I can make save as new and save it...By default, it will keep all the references relative to the newly created sheets. what if I added a new sheet to folder A and I included some references,…
-
Issue with COUNTIFS Formula Referencing Auto Number Column in Smartsheet
I am currently working on implementing duplicate detection logic in our Baseline sheets within Smartsheet. The requirement is to identify duplicate Project Codes and assign a sequential baseline order (1st, 2nd, 3rd, etc.) based on the order in which rows are added. While attempting to implement the logic using a COUNTIFS…
-
Networkdays bring back #INVALID DATA TYPE error
Hi, I am trying to get the networkdays from 2 diffrent dates. Here is my source data. I have the same formule for diffrent type of packet movement. Here is the formule I am using to retrieve the dates to a diffrent sheet. Here is the formule I am using to get days between the 2 dates If I take the formuls out and just type…
-
Help with functions for attendance tracker
I'm attempting to create an attendance tracker that will add up the total points for a given representative based on the type of 'event' such as No Call No Show, Late Arrival etc. I have a sheet set up that automatically enters the number of points based on the event, calculates any adjusted points and shows points…
-
Tracking days
Thank you in advance for any help you may be able to provide. I need to track how many days between “Date Received” and completion of certain tasks (i.e. "Date Assessment Completed", "Date Report Submitted/Completed", "If in Progress Running Days Count"). For example - I can get it to show me how many days between “Date…
-
Copy Single Cell to Cross reference sheet
We’re using a portfolio management tracker. When a dropdown field in the Regulatory column is set to anything other than “N/A,” I want to automatically copy just the Initiative Name, Regulatory Dropdown, and Owner columns to a different sheet in the same workspace. I do not want to copy all columns—only these specific…
-
Formula not Calculating the Correct Number
Hello, I have a formula that counts notifications that are tracked on another smartsheet each month. The formula is: =COUNTIFS({Date of Notification}, >=[Start Date]@row , {Date of Notification}, <=[End Date]@row , {Impacted Department}, <>"XX") The results from this formula are no longer calculating correctly. For…
-
How do I use AI for Summary formulas
Hello - I am trying to set up some Summary Fields and the formulas needed are a bit above my skillset. I use the AI assist to generate a formula, but I cannot figure out how to add to Summary fields rather than to a specific cell on the Sheet. Also, I am getting error messages on formulas that seem logical and pretty…
-
Number of Days from a given date against the current date
I need to get the number of days ( just a number ) from a given date against the current date. I need to know Column 2, to show the number of days to the coloumn 1. Ex: Column 1: ( ETD ) 28/02/26 Column 2: (Number of Days to ETD ) 5 ( if the current date is 23/02/26 )