-
Harvey Ball formula that reads across and produces cumulative
Hi All - I would like a formula that reads across vs vertically - here is my vertical one. I need the same thing but read about 10 columns status to then come up with an overall status meaning if there is 1 red, 7 yellow and 2 green then the overall cumulative status is red (lowest common denominator) Vertical Formula:…
-
Global Updates and using VLookup formula in it.
Hello all, I wanted to know is it possible for us to do find and replace in global update and change a Vlookup formula or to introduce a new Vlookup formula. I am trying to do that and i am not successful in accomplishing that. Please some suggestions.
-
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…
-
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…
-
Project Dashboard Generator
I am trying to develop a dashboard generator so that I don't have to recreate every report I use in our dashboards each time we have a new project. I would like to be able to select the project number in one location and have all the reports reference that project number to pull data from their respective sources, then…
-
Tracking Data / Shared Sheet
Hi! I'm really enjoying Smartsheet and glad we decided to go down the path of subscribing. While I was getting certified I found so many neat features and my mind just filled with all the things I could probably use various aspects of Smartsheet to accomplish. I ran into a limitation in my own scope that I'm sure…
-
Forms with multiple levels
Hello, I'm hoping for some advice on how to create a form with multiple levels. By levels, I mean that some of the information submitted on the form will stay the same and can span many line items on my grid. That would be one level, and the second level would be additional information that would be different per each line…
-
how to receive excel file notification for the newest update in smartsheet ?
Hello, for the current smartsheet, for each new/update records in smartsheet: we receive an email notification for these updates. that is great.., however, in stead of receiving an email with all the new/update records on that email. are we able the send all the update/new records as an attachment - (excel format) via that…