-
Control Center & Cross-Sheet References
Hello all, This is my first attempt at SCC provisioning of sheets and I ran into my first problem. There are three sheets in the blueprint -> Sheets A1, A2, & B. B pulls in data from sheet A1 and A2 via cross sheet references (index/match so I can reference by a key value in case rows move around in A1 and/or A2). When I…
-
Help! Refrence using =INDEX in a drop-down single select
Hi All, I'm new to Smartsheet, id like to use =INDEX formular reference to reference another sheet cell. when i select a single option in the drop down it will reference that cell.
-
Copy Date from Formula to another Sheet not working
Hello- I have one sheet with a Form attached. When users submit their form, I have a formula that will convert their some of their selections into start and end dates. Sheet 1 I then have a second sheet where all rows are copied from the first sheet that serves as a Calendar view for the created dates. I did this because I…
-
Can a checkbox in one sheet be auto-checked based on a checked checkbox in another sheet?
Hi all! Can a checkbox in one sheet be auto-checked based on a checked checkbox in another sheet? I've looked through multiple help resources but can't seem to find a situation that specifically matches my set-up. Here's what I'm looking to do: If the same Product Code exists in columns 1A and 1B, AND column 2A is checked,…
-
Search and Replace in formulas
When importing from Excel I need to fix some of the formulas. This would be easy if I could use a search and replace within all the formulas on the sheet in one go as you can in Excel. Does anyone know if there is a way to do this in Smartsheets?
-
Changing value in cell
Hi All, I am new to Smartsheet so any help is appreciated. Currently trying to use multiple sheets/forms to record inventory by scanning a basic barcode. I have setup form entries to be duplicated in another sheet but the value of the barcode in numbers (ie: 407621031) needs to be recorded as the item name. For example, I…
-
Countifs & NOT formula help
Ok so I want to count if the following criterias are met: BDM Column {cdatBDM}= BDM@row (BDM2) Date Column {DateCDAT}<= Todate@row (To1) However, I do not want it to count Category Column {Category} if it says "Portfolio" I tried the following to no success: - =COUNTIFS({Category}, NOT({Category} = "Portfolio"), {cdatBDM},…
-
Help creating formula for project prioratisation
Hi there Im fairly new to Smartsheet and was looking for some help creating a formula to help populate the score for each project within the team, to then help prioratise each project. Have found a useful Smartsheet excel template and corresponding formula but cant seem to apply that to Smartsheet. Below is the criteria…
-
How to Separate Text?
Hello, I have a list of names and I want to separate them by last and first name. I am not seeing a function to accomplish this in Smartsheet like you would in excel. =TEXTBEFORE(A2,",") and =TEXTAFTER(A2,",") Full Name Last Name First Name Barbosa, Fred Barbosa Fred Any suggestions?
-
Having a tough time with time calculations
Hello Everyone, I have been referencing the Time calculation post: How do I create time of day columns? - Smartsheet.com For some reason the very last formula listed below returns all the minutes as "00" instead of the actual minutes. I am basically copying the formulas listed in the above link except I never have to worry…
