Auto-Create Child Rows WITHOUT Bridge or API
This initial solution is based on form submissions being made and each form submission triggering the creation of a set of "template" child rows per submission WITHOUT the need for a 3rd party app, the premium add-on Bridge, or the API. So if your form submissions look like this: Your working sheet could look like this:…
Compare Text between columns, one with text, one without, and return the text.
I have created a form that is for use with two separate groups, fields become available dependent on how respondents answer questions. I have a VLOOKUP formula set to pull in the address information from another sheet. Because this is used between two separate groups, there are two name fields. I am trying to compare both…
Inconsistent Formula Issue #INCORRECT ARGUMENT SET error
Hello, I am working in a sheet summary and I am using a formula to count the number and type of maintenance issues after a certain date. My issue is that I am using the exact same formula in different fields in the sheet summary and only changing the text in a countifs formula. It works in some cases but not others. For…
AI for formulas
Can anyone tell me why I know longer see this on the right hand side of SS to help build formula's?
What is the process for signing into DocuSign. My account has the enterprise license. Thank you! Gail Coleman
SLA Calculation Strategy
Background: There are four (4) SLA priorities in the Ticketing intake: Critical = 4 hours: High = 8 Hours: Medium = 24 hours: Low = 48 Hours Using the Created Date (including both Date and Time) I need to create the Planned SLA Finish for each ticket. SLA Plan is expressed in Hours This needs to also be a Date and Time…
Formula Issue - Invalid Operation
=IF([Time Due]@row > [Day End]@row, [Day Start]@row + ([Time Due]@row - [Day End]@row), 0) Getting an "Invalid Operation" with the above and cannot seem to see it. I really think I have been looking at this Ticketing solution for too long.
Email addresses for sheet attachments?
Is there a way to attach a document at the sheet level, via email? In other words, I want to send an email with a document, and have it automatically attach to a specific sheet.
How do you get the URL for the Calendar so that others can view. I tried the Open Sheet, but cannot find the "Web Form" anywhere.
"New" Outlook Add-in Not Working
Outlook kept prompting me to switch to "new" Outlook, but my Smartsheet add-in isn't functioning with it. I believe it's a SS issue, not a system administrator issue because other add-ins I used previously are working just fine (Box, OneNote, Teams). Will this be fixed soon?