-
#INVALID DATA TYPE
Hi All, I have problem in sheet summary formula after edit sheet Everything is working as well with current formula, but after I edit (Just change type column, insert) then all formula in sheet summary show #INVALID DATA TYPE. Would you please to help me solve this one! Kindly refer my picture as below with current formula…
-
Card viewed by Dropdown list field
Hello - I have a few columns w/ dropdown lists. For some reason when I switched to Card view only three columns appear as option to view by. Why is that? How can I add another column as level? Thanks, Lina
-
Prepopulate form with information
We are wanting to send an email to our customers asking them to confirm whether the company/contact details we have for them are correct. This means we would need to upload the details we have into a sheet and then send them a link to check their details specifically. We don't want them to have to populate a blank form…
-
Update Requests: Automatically Ask for the Latest Info.
Dear all, I want to let my colleagues edit an existing row on Smartsheet by asking them to fill in an update form. However, the tutorial link is broken. Could anyone share the method to do that? https://help.smartsheet.com/articles/504779
-
How to sort a column without sorting all the columns
Hello, I want to sort columns alphabetically but not have all the other columns sort at the same time. Eventually, I want each of my columns sorted alphabetically but as if they are a stand-alone column and not impact other columns. When I try to sort a column, all the rows associated with that column also sort…
-
Use data from a form field in the alert email title.
Setting up an alert system that sends out notifications when a form has been completed. To streamline the process I would like to use a field from the form in the email title to differentiate between the emails rather than a range of emails with the same title. Is that possible and if so, how? Cheers
-
Bugs: SUMIFS does not find multiple users
Scenario #1 Multiple Resources assigned to Contact List type column (new release today) This =SUMIFS(Amount:Amount, [Assigned To]:[Assigned To], CheckName@row) does not match the [Assigned To] when the Contact name in [CheckName] matches. (It does for single instances) Scenario #2: It is possible to possible to get into…
-
Build an automation that creates a new row once a month
Hello! I did some searching but could not quite find what I'm looking for. I'm wondering if Smartsheet (now, or in the future) will have the ability for me to create a workflow automation that will run periodically (once a month) to create a new task/row. The use case is to create a new task on a monthly basis to have a…
-
3 unique automations pointing to 3 different sheets
Ok, I need some help from you SS wizards. I have crated a new form. This forms allows follows the logic path for 3 different request selections (job, project, video). I have 2 different automations set-up approval / decline project If approved copy row to separate sheet (job, project video sheets), depending on what the…
-
Sheet Summary Report and Dashboard Widgets
Hi! Can I use a Sheet Summary Report to drive a Metric widget? I have 25 project sheets that I would like to roll-up into a sheet summary report. I would then like to create dashboard metric widgets using this data. I am currently driving the metric widgets off of the individual sheets, but this is getting cumbersome as we…
