-
Does anyone know if you can have automation to copy attachments over to another sheet?
I am trying to see about having attachments copy over to another sheet with different row columns. I have a reference cell that would be the same across but data mesh doesnt mesh attachments. I know I could do a work around but not 100% sure how with different column names across to then copy to yet another sheet.
-
Percent Complete Based on Checkboxes
I know this should be so simple and I have tried looking at the Help and Community channel but still getting hung up. All I want to do is based my % Complete on 4 checkboxes, if the checkbox is checked. Note, that I have columns hidden between these checkboxes. I've tried: =COUNTIF(([IDR 2 Completed]3, 1) + COUNTIF([G2…
-
Multi-Line Chart from Imported Excel Data based on Counts Per Date
Hello! Got a problem that's confusing me because I'm used to Excel and can't find a way to do this on SmartSheets. Context: I have a CSV that I export from a database that contains info about design issues such as ID #, Status, Create on Date, Updated on Date. I'm using Smartsheets as a project management tool and I'm…
-
Highlighting duplicates
Hi all, I am trying to create a sheet that will highlight a duplicate entry in the Les Olsen ID column. I researched the subject and found the advice to use a formula like this =IF(COUNTIF(Column:Column, Column@row) >1,1) but when I try to apply it to my sheet it shows up as UNPARSEABLE. Can anyone tell me why this isn't…
-
Return Row ID / Row link in cell?
Hi all, Looking to leverage a function that clearly exists in Smartsheet, but doesn't appear to be a user-side feature: Application: I have a report with two sources. Essentially one is an intake log generating new 'Change Request' UIDs, whereas the second source is approved requests which are given 'Change Order' UIDs. I…
-
Summarizing Time in a Report
I have a master Smartsheet that lists every course we assign in our Learning Management System, the course length, and who all it is assigned to. I then have several reports set up so I can filter the courses by Service Line, Level of Care, New Hire, etc. It is Grouped by Due Date. This then feeds into a nice Dashboard…
-
Using Distinct Count based on other criteria
I need to create a formula that will show me the distinct count of an Assignment number, for Team 1 if the date is 3/10/2025. I have a sperate sheet set up referencing this sheet. I'm able to get total count, but not distinct.
-
Identify Most Recent Record
Hello, I am using SmartSheet to log Training Records. Every time a record is submitted, I am recording three fields: Date, Name, Topic. Based on the date, I am projecting forward the next time training needs to occur. (ie: 3 years after most recent training record). This occurs in a "Renewal Date" Column as a column…
-
Avoiding #Circular Reference with Dates
I have a column [PDU (Next Update Date)] that tracks the date a notification should go to a Program Developer with a link to a form to provide an update on the progress of a development. This notification goes out every two weeks, starting 2 weeks after the project enters Stage 1 (in [Status]. The date it enters Stage is…
-
Why is my =SUM formula calculating incorrectly?
Hi there. I have a pretty simple formula that is incorrectly calculating the sum of four columns. Depending on how I construct the formula, I'm getting two different values, but both are incorrect. I can't figure out the issue. =SUM formula: =SUM([Score: Has Start Date]@row, [Score: Has Delivery Date]@row, [Score: In…
