-
Best way of Counting a given number of States
Hi there, I am trying to have a graph display the count of some things across multiple sheets (~40), as shown in the screenshot. The only way I could think of for now was to get the data by cell linking and doing some calculations on it in an extra sheet. As it turns out now, doing all of this "manually" for multiple…
-
"Recently Opened" Navigation bar Question
Hello All, I have been a huge fan of the "recently opened" Navigation tab and have about 30 sheets pinned. I do use various sheets at various times, however, and would like to rearrange the order of these sheets as well as be able to bucket them. I understand that this wasn't quite the point and workspaces/sheets were made…
-
The new prices have stopped FREE USERs to SEND line of a Sheet
The new policy has change the rules, Free Users are no more able to send line of a Sheet . There are some Workspaces where you can ten or more free user who need that to share. And 120€/users is to expansive now to do it. I send 2 requests to Smartsheet. Support Case Number: 03599177 Support Case Number: 03595187 but no…
-
Taking a dashboard "snapshot" as a pdf and attaching to a given row
While the header of my question seems confusing, hopefully an easy solution exists somewhere. I have a complex smartsheet's dashboard created which has metric widgets filled with values that update every time a new form is submitted to a sheet ("sheetX" for later reference). What I want to do is try and capture a part (or…
-
Random highlights appear
We have noticed over the last 6 months or so, that there is a persistant bug when using the "highlight changes" feature. The smartsheet will highlight changes within the given date range. However, it will also highlight other random cells. The highlight will also disappear if you move the cursor over it, but will reappear…
-
Need to calculate an Expiration date
I have a sheet that I have included the current inspection date. I need to calculate two expiration dates. One column @ 90 days post the inspection date and one column @ 365 days post the inspection date. Any help would be greatly appreciated. Thank you, Nicole
-
Flag By Date Column 6 Weeks or Greater in the Past
Hi, We have an order intake sheet that has an "Order Date" column and a Status Column. One of the ten selectable statues is "Complete" What is the formula that I can use in a flag column to say - Flag any with an Order date 6 WEEKS OR GREATER, and Status NOT EQUAL to Complete? Thank you so much in advance! Jared
-
Automatically Adding Rows Based on Change in Another Sheet
I would like to be able to automatically populate rows in a sheet based on the change in status in another sheet. For example, if I have a spreadsheet of jobs I'm bidding on that has a column with dropdown options of "Bidding", "Won", and "Lost", I would like to have a sheet that auto-populates a row in a different sheet…
-
Ghost data from unused SCC template remains
I have three different gantts with some summary data that is fed into the main project data sheet. Only one of the gantt sheets is used in a project, so I thought of linking each of the gantts' data (exact same field/cell in each sheet) to a cell in the project data sheet - then just grab the one that isn't blank or an…
-
Update date field error
Hi. I'm trying to update a cell on a row which is a data field using the C# api. However, I'm getting an error {"Value is not supported for this column type. Use objectValue instead."} But when I'm trying to set objectvalue i get an error due to protection level I know I'm doing something wrong, but i dont know what :P