-
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…
-
Formulas to Add Meeting Date and then Corresponding Due Dates?
My company has a regular meeting with a client, with required notes due 3 days later, for several years. I am looking for formulas that will help me do this efficiently, but I haven't found answers with searches. 1) Is there a formula/function to find the last Monday in a month? This info would go on the monthly meeting…
-
Count Multi-Select with conditions
I have a ongoing sheet with Clients (Single Select Dropdown) and Tests (Multi-Select Dropdown). I'd like to know the ongoing total of Tests selected per Client. I can't seem to figure out if this is a combination of Countifs and CountM or if I should use Collect, Has, Contains. I know this is simple I just can't put it…
