-
How to count symbols in smart sheet ? example the risk flag
=COUNTIFS({Main Deck Range 1}, "Body", {Main Deck Range 2}, [34 System - Unassigned]1, {Main Deck Range 4}, <>"", {Main Deck Range 8}, 1) This formula doesn't seem to work Range 8 is the reference to the column that has the symbols
-
Using Star Symbols - Two star is missing
Hello everyone, I can assign the column type of symbol and select the 5 star type. Oddly, the two star selection does not display. (See screenshot). If selected it also shows no stars. I tried recreating the SmartSheet but the experience is the same. Any ideas on fixing this?
-
How do I add more months to my existing sheet?
i use Smartsheet for my restaurant and I need to add 2019 to my already existing sheet. How do I do this?
-
Ensure a cell value is unique OR if already used, match the previously used value
I'm completely new to Smartsheet so I may be overcomplicating this, or going about it the wrong way. I want to ensure the value entered into a field is either unique within the column, or if it has been used before, then I want to to be exactly the same as a previously entered value. The use case is: I have a Smartsheet to…
-
Email daily comments on (multiple) sheets
This seems pretty basic, so not sure if I'm missing something. But, certain project stakeholders like to receive daily status emails that show the project activity. When I say activity, I mean comments, not who changed which cell. Currently the only way I've been able to do this is the literally grab screenshots of the…
-
Column Not Found
Hello! When I am filtering down information from a sheet into multiple reports, a few of my columns are labeled as 'not found'. I haven’t renamed the columns, which I understand could cause this -although on one of the columns I changed the column type from 'symbols' to 'text' fairly recently (but not for my other one).…
-
Vlookup
Hello, i have a sheet with billed claims including a column "Pending Amount", and "Detail ID", each line item has a different detail ID, now i want to update the pending amount column according to another sheet, i tried the simple Linking Cell method but it did not imported the pending amounts to the right detail ID's. and…
-
Important Reminder doesn't say Row # or Primary Column Name
I just filled out a large CRM on a new sheet with several hundred clients. I was using the reminder feature to remind myself to send certain people an email or more information. Out of the 18 reminders I created, 11 of them tell me the row # and primary column name, but 7 of them only say "Message: [my reminder message]".…
-
Smartsheet Barcodes
Hello All, I have a sheet that has a specific barcode for each card. Ideally we would use the barcode functionality to scan an item, then select the option to bring you to the correct card. With it set up, when I go to test it, it only works occasionally. It will usually only bring me to the column that the card is in and…
-
Translating Data from One Sheet to Another
I am looking for any method that could help me obtain the desired results. I have a tracking sheet titled “PM Sales Tracking” and within the tracking sheet there is a column that is called “Design Request” I have edited the column properties(design request) to a “dropdown list” with values of “yes and no” depending on the…
