-
Linking Parent and Child Rows with a Unique Identifier
Looking for a way to tie Parents to Children with a numeric value, so if they become separated and lost in a sort, they can be easily found and nested under the correct Parent again. We have an automated [ROW ID] column to reference. We created a [SLIP ID] column and used =PARENT([ROW ID]@row), and it does populate the…
-
Cell character limit
I'm new to SmartSheet. I just imported a worksheet and the column headings in row 1 were truncated to 50 characters. I see that SmartSheet allows 4000 characters per cell. It won't let me go pass 50 characters. I have changed the cell to "Text" but still can't go pass 50 characters. Is there a limitation on imported…
-
Formula to Sum Data for Specific Month in 2024, Not Entire Year
This discussion was created from comments split from: Return sum of one column if today's date is between A and B, etc.
-
Trigger approval request based on submitter info
My org's travel request form goes through two approvals, first the submitter's direct supervisor approves, then the COO approves. I know I can have the form submitter choose their supervisor from a list of approvers on the form to trigger the first approval request that way. Is there a way to omit that step from the form…
-
Date between dates to return the date in cell
Hello, I am struggling with one of my formulas: =IF(AND([Start Date]@row, >=DATE(2020, 10, 1), [Start Date]@row, <=DATE(2021, 9, 30)), [Start Date]@row, IF(AND([End Date]@row, >=DATE(2020, 10, 1), [End Date]@row, <=DATE(2021, 9, 30)), [End Date]@row)) If the start or end date falls between the dates in the AND statement, I…
-
Personal Identification Information
Hi - I work in a K-12 environment where Google forms and sheets have been utilized for years. I am trying to transfer a few workflows to Smartsheet for better efficiency. The issue I am running into is PII. I need more than one data point to reference a student. My IT team does not think Smartsheet is secure enough -…
-
Workspace & Sheet Sharing Permissions
I've noticed recently that workspace owners are not automatically made the sheet owner. Previously, I thought that if a sheet owner moved the document to a workspace outside of their ownership the sheet ownership would be transferred to the workspace owner. Is this not true anymore? Additionally, I've moved sheets to…
-
Can Created By Column be Wrong?
One of my users reached out because they received a notification in which they are ID'd as the creator of the project request, which they claim to not be. I checked the source sheet and they are indeed listed in the "Created By" column with a date about 1 month ago. You have to log in to enter requests in my form and I…
-
How to create a stacked column chart from a report
Hi everyone, I'm trying to create a staked columns chart in my dashboard to show per Assigned to the number of cases per status. However, the chart shows up just as 1 big column. Would someone knows why? Please see the photo for visual. Thank you in advance for your help
-
Multi-License Requirement
Has anyone else run into the new requirement in Smartsheet to have anyone you have built a Smartsheet to have a paid account under your license? Smartsheet wants $9,000+ for the users I have built sheets for or assisted on. This is insane. This will be the end of me recommending Smartsheet as a solution for clients.
