-
Line links between different sheet
Hi everybody, wouldnĀ“t it be nice to link not only cells but complete lines between different sheets. Off course it is a question of matching collum names. But a simple possibility would be to match the cells by column name. Not matching columns, cells with systemĀ valuesĀ or cells with formularsĀ could beĀ ignored. A littleā¦
-
Custom Views
Hi everybody, this is probably not a new one, but I've not been able to immediately identify the right thread - therefore let's try again: We've started a new sheet with some intense collaboration, and everybody has his preferred view in the meaning of what to collapse and what to extend (preferences as well change overā¦
-
Nested IF formula using additional AND/OR logical functions
Hello everybody, I am struggling with creation of formula for defining Invoice Status Symbol (RYG). Geeting the UNPEARSEABLE error message. My formula is right now as follows: =IF(TODAY-[INVOICE DUE DATE]11>30,"Red",IF(AND(TODAY-[INVOICE DUE DATE]11>5,TODAY-[INVOICE DUE DATE]11<=30),"Yellow", IF(OR(TODAY-[INVOICE DUEā¦
-
Function that temporaly stop the sharing of the sheet
Hi, Is there any function that I can temporaly stop the sharing of the sheet when I'm doing the amendments? Instead of all the members always receiving an email about the changes of the sheets. Note: I'm also the owner of the sheet. Cheers Quece
-
COUNTIFS with various values?
Hi all, I'm trying to count the number of times my brands are used in each state, but the column I'm trying to query has three different values. The data looks like this State Brand State 1 Brand A State 1 Brand A State1 Brand B State 2 Both State 2 Brand A Since "Both" includes two brands, I will need to count it twice. Iā¦
-
Countif with wildcard
Need some ideas how to count number of cells in a range with any text in them. The formula below returns 0 (when all cells in the range contain text) =COUNTIF(Column Name]10:[Column Name]19, "*") Any ideas for text wildcard? Thanks
-
Auto-Number starting with 0
Hi I spologize in advance if I've already asked about this (it has been rattling around in my head for a little while but I can't find that I already posted this question on here). It doesn't appear that you can begin AutoNumbering with 0. Whenever I try it, it just defaults to 1. Am I doing something wrong? I would likeā¦
-
Trouble with Downloads
When I click on an attachment, the file starts to download, but the process doesn't seem to make progress and the download never completes. Thsi has been happeneing for about 4 days now. Any ideas?
-
Problems writing zip codes starting with Zero "0"
Hello there, I'm unable to put in zipcodes starting with "0" in the Text/Number Column, it autmatically removes the zero's leaving only the whole numbers behind. Is there a way to disable this feature? Regards, Paul
-
Reporting Services down?
I am unable to open any of my existing report , here is the error message: an unexpected error has occured running your report and the smartsheet.com team has been notified. Am I the only one?