-
URL to jump to a row in a sheet? Unique identifier for sheet-row combination?
I am looking for a way to have a URL that will allow me to jump from an external source to a specific smartsheet row. For example, if I were to have a Google Sheet which I was doing some calculations and I wanted to have a link corresponding to each row in a Smartsheet to let me click on that link and go directly to that…
-
Help locking a column
I locked a column (im the admin). But somehow another user that has admin permissions as well was able to change a cell within the locked column. It erased the formula. Am I missing something? How do I make it to where I'm the only one that can change the cells in that locked column. Thanks in advance.
-
Columns Filters on Phone/tablets
Hello dear Smartsheet community. It appears to me that it is only possible to apply "Preset Filters" on smartphone/tablet Smartsheet App. Those named filters presets created on the "browser" version. Using the Android application I can only find the "sorting" option for individual columns, no column "filtering". Only…
-
Convert multiple text dates to a date field in a single cell
I have contract information entered into my sheet via Web Form. The users are allowed to enter multiple products in at once but asked to keep information pertaining to them in the same sequential order throughout the form entry. I am looking to see if it’s possible to take multiple text dates entered in a single cell and…
-
SUMIFS - Contains value in cell from another sheet
Hi All, I want to create a "Total Vendor Paid Amount" column on our "Main Dashboard". This column will need a formula that pulls information from another dashboard called "REO Vendor Invoicing (3)". I want the formula to sum the total invoices paid, in the "REO Vendor Invoicing (3)" dashboard, of jobs that contain a cell…
-
Countif - Want to count number of times a word appears, multiple then divide by a certain number
I'm creating a pricing sheet and need to use the countif formula. I am counting the number of times "High", "Moderate", "Low" appears in the column and times by 3, 2 or 1 then dividing it by the total count. For the sake of space, I named my column "G". Not sure if Smartsheet recognizes the "+" in the formula…
-
Can I have the default value be a function?
I have a form that asks for someone's name. Most of the time, the form is for that person. There are some cases where a person might fill out the form on behalf of someone else. What I'd like to do is have a "name" field and a "on behalf of" field. If "on behalf of" is blank, I'd like it to default to the value of "name".…
-
Best way to append text in a cell?
Hello, We have a project tracking sheet into which people will be adding status updates to a particular cell. Is there a way to easily append the text to the previous text so we can retain history? People can use "Alt-Enter" to create a new line but then cells get very large. Is comments the best way to do this? People…
-
What's wrong with my RYGB formula?
Ok, I'm feeling really stumped. I have this formula for changing the color of the RYGB balls based on the number in a specific cell but it is returning an #INVALIDOPERATION on anything except zero (when the ball turns blue). Where am I messing this up? =IF([# of Days from Submission to Assignment]@row = 0, "Blue", IF([# of…
-
Is there a way by which users can only view their rows instead of having rights to view other users
Hi All, Is there a way were a user can just view and edit his/her rows and he/she shall not be able to view other user rows. Example: Attached screenshot.I have two contact David and Charles. Now, If David wish to update his data on the sheet he would not be able to view Charles rows vice versa.