-
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 )
-
Is it possible to transfer references between sheets?
I have an issue where I have to add a round of references to a new sheet and it's one update per column for about 30 columns. It's easy to add the new lines in the formula, but creating the references is time consuming. Is there any way to quickly transfer preestablished references from one existing sheet to another?