-
C# API access to row attachments
Greetings, I have been able to use the Smartsheet C# API to access sheet and cell data without issues. I added an attachment to a row and attempted to get information about it via the API: // Load the entire sheet Sheet sheet = smartsheet.SheetResources.GetSheet(selectedSheetID, null, null, null, null, null, null, null);…
-
What formula do I use to count a specific text when multiple text values are in a cell?
I have a column with a drop down where you can select multiple options for one cell. It is tracking who is affected so it can list multiple departments. I want to track by department so I am trying to figure out how to count only a specific word in a cell when there are multiple valves in the cell. The formula I am using…
-
Copy row when certain criteria are met and edit data within the row
Hello, I am managing a list of products where our customers often re-order the same product the following year around the same time. I want to copy the product specifics to the bottom of the sheet once it is checked as delivered and add a year to the due date. This will allow us to plan for the product delivery the…
-
Date Formatting from a Formula
Hello, I'm importing dates from an excel sheet that have a time stamp, and I have a formula that removes the time stamp in Smartsheet. This is fine except the date won't convert to 00/00/00 for that column. Does anyone know if there's a way to covert the format? Thanks
-
Count and Occurrence of Duplicates in a Column
I'm trying to count the number of duplicates in a column and then number those duplicates in another column. For example: I'm using the formula COUNTIF([Legacy ID]:[Legacy ID], [Legacy ID]@row) in the Multiples column to count the number of duplicates in the Legacy ID column. I need help with a formula to create the MCount…
-
Color Coding for Calendar View
Hello, I need my calendar view to be color coded without having to manually change the color in card view. Has anyone figured out how to automate the colors? Thank you! Beth
-
Simple Workflow Not Triggering
Hi, I have a very simple workflow set up using "TODAY()" date as a formula. Basically it's a tracker with due dates, and if a particular task is not "Complete" by the due date, the status will change to "Overdue". Let me emphasis that there are no external links on this sheet and the formulas work fine. The workflow is as…
-
How do I remove myself from a group?
Hi. An unknown individual / party has added me to their group, and I'm unable to exit that group. It's too annoying! Any fool-proof tips please?. Thanks
-
Now Announcing - Data Shuttle Error Notifications!
Hi Community, I am beyond excited to announce a much anticipated Data Shuttle feature - workflow error notifications! As a Data Shuttle workflow owner, you will now receive in-app and email notifications for erroring workflows with links to the run log so you can see details about the error. You can learn more about Data…
-
Date Format
This discussion was created from comments split from: Welcome to the online Smartsheet Community!.