-
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.
-
Resource Check Out
Hello, We are trying to use a Smartsheet form for check out equipment from a drop-down list. Is there any way for the Form to not display an item is available for check out(I.E. remove it dynamically from the dropdown list) if it was checked out by a different staff member? regards, Brian
-
Do Filters Work Correctly?
I created a filter that: * Shows rows that match <all conditions> * <Status> <is not one of> <3 values selected> (DONE, DEAD, LATER) * <Archive> <is unchecked> The instructions my team is getting are that they can flip tasks to DONE and DEAD, but they won't be hidden from view until our next meeting where they are then…
-
Exporting Sheet Content into a Formatted View
We have a Smartsheet that is being populated from a webform that is collecting scholarship submissions. We want to provide a summary page for each application that includes the questions and answers. So if the sheet has 10 rows (applicants), we want to generate 10 different summary sheets in a view that is easy to read.…