Hello, I'm trying to setup a "Line Quantity" of children where the primary column contains a 5 digit number. These numbers indicate line items of a purchase order and have a hierarchy themselves. The numbers that are considered the parent end in 000 with all the items that are children end in various numbers in increments…
I am using curl with REST to access Smartshets in my C# running on WIN CE. My application is supposed to dump some data on smartsheet periodically. Before I write to a sheet, I would like to know the total row count in the sheet so that I don't exceed 5000 rows per sheet. I am looking for an API that would return just row…
I would like to request the ability to use different format options in the comments window. We are currently able to add plain text comments but it would be nice at times to use a different format like Rich Text or HTML.
I trying to use to create a sheet that I will use to determine the status by comparing 2 status and then give an answer the e.g. If the status1 is low and status 2 is low the actual status should be low, I used the following IF/AND Statement and it worked fine: =IF(AND([Status1]3 = "Low"; [Status2]3 = "Low"); "Low"; " ")…
Hi, I understand that only License user can hide or un-hide column in sheet they are admin. * Hide/unhide columns (also requires Sheet Owner or Admin access to the sheet) But we have some user (non-licensed but part of our Business) that are able to shrink a column in a sheet they are admin, but they are unable to unhide.…
We currently use a considerable number of sheets that need numbers to read as fractions. (Construction/Exhibit Industry for dimensions) Unfortunately, if you type out a number as a fraction it cannot be used in formula. Excel can translate easily between decimal and fractional display with cell formatting. Will there be a…
Hi all, Is anyone else having issues with cell linking? I can no longer get it working.... It was all fine until about 4 weeks ago and now nothing will link?
Hi there, I'm currently operating on an Enterprise level version of Smartsheet and experiencing an error with my dashboard. Does anyone have experience embedding a Tableau Public link directly into a dashboard via widget? I see that this is an option and have tried both the link & embed codes, which both return the same…
I cannot get a notification to fire to the name in the "Assigned To" column when a new row is added. Screenshot is attached. Automation Permissions are set to "Unrestricted" The contact is shared to the sheet My personal settings are checked to include my changes in sheet notifications. And, I checked the SS status page…
Hey Community members I have a sheet that is tracking reporting compliance. Most of the reports only have ONE due date (typically reported annually ie 30th June), but there is a number that requires monthly and quarterly reporting. To allow our users to enter up to 12 dates for a reporting cycle we have 12 fields to…
