-
Error Incomplete or Invalid when Submitting Form
We have several users getting this error when trying to submit a form even though everything is filled out correctly. It seems to happen when using AutoFill to populate fields on the form. Has anyone else experienced this? Thank you
-
Fiscal Year "lookup" formula request
Hi :) I'm trying to get this lookup to pull in the FY for us but these always give me a hard time. I have the excel formula but I don't really even understand it so not sure how to translate it to Smartsheet talk. Excel: =LOOKUP(2,1/((H268>='Lookup Data'!$B$2:$B$21)*(H268<='Lookup Data'!$C$2:$C$21)),'Lookup…
-
Converting an Excel Formula into a Smartsheet Formula
Hi, I am currently transferring a lot of our excel spreadsheets to smartsheet and have found it ok so far. However, I have got the below formula to convert and i can't seem to do it. I feel like I am missing something before the [D1 Total solid feed (t)] at the end but can't work out what, my brain is fried! =IF(S2>0,…
-
Nested If/Then Quantry
I am working on find tasks that are of the Action plan or Key task type that have not been completed yet but have a due or publish date in the past; or have a due or publish date within the next 90 days regardless of status. Put another way: I have been building and testing but git stuck at:
-
How to convert multiple email separated by commas from Text column to Contact list column?
I have a text column that has multiple emails and each email is separated by commas and i am trying to pull those multiple emails to contact list columns (I have allowed multiple contacts per cell ON) and be able to send alerts. However, when I do that it just stays as text, not contacts. Does anybody have any idea how I…
-
Automations: include attachments
When selecting attachments for an Automation Workflow, we should have the option to include all the attachments in the notification email instead of sending only the last attachment if it was attached after the last save of the sheet.
-
Cell Linking Across Sheets
In our workspaces, Linking cells across sheets has been a bit cumbersome using the existing option in Smartsheets (please refer to the attachment). It would be great if Smartsheet can introduce a “paste special” option where I can copy the content of a particular cell (or cells) from one sheet and paste it as a link into…
-
Automation trigger not working with filters/conditions
Afternoon, I've a workaround automation that I'm using for a course training registration sheet (linked with forms) to send to specific people once we've reached a certain number of registrations for that course/component, so they're aware of the numbers and to close off the form due to the limit being reached. I've used…
-
Use the children function to display infomration in parent row based on child values
Hi There, I am trying to get the parent cell to say "Estimates Incomplete" if one or more the children has the value "No Developer Estimate Yet; not complete" I searched through the functions and have tried a few things, but nothing is giving me what I want. Do you have any suggestions?
-
Company Holidays
Currently Holidays can be configured in 2 locations on Smartsheet. At the administrator portal and at the sheet level. It would be ideal if at the sheet level you could select pull in holidays from your administrative settings. This should be something you can do when creating a new sheet from a template so that you do not…