-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Set Up Conditional Formatting to Enter Current Date
I'm fairly new to setting up my own SmartSheet pages and was wondering if this would even be possible. Is there a way to link a Date column to a check box or a drop down item? For example- I want to have it so that when a certain item is selected from the Dropdown list, a Date column would auto-populate with the current…
-
Exporting Excel formulas
I noticed that formulas, even simple formulas are not exported to a Excel. I have a big smartsheet where we created butcket that has additions per row (summarized) and we noticed that they're not exported as formulas in Excel. It's a shame because we have to start over in Excel an create template and data again. Is there…
-
Formula help - due dates falling on weekends
I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays. Now, I want to move those dates to the Monday next. Is there a way to automate that? Ultimately, I need the best way to…
-
Formula assistance, please
Good afternoon, I'm not even sure this can be done, but I'm giving it a shot. The picture below is a snip of the sheet I'm working on. I'm wanting to figure out if there's a formula that will put the data from a single cell on the Sep row to the "Current Month" row - but the catch is that is needs to look for the last…
-
COUNTIF between Dates (Children) || Summary
I have a formula that is troubling me. I am trying count between two date ranges so I can count the number of shows due (between a set date ranges or set to count only the next 14 days). The forumla below is returning zero. Is it the forumnla or a setting? The screen cap below is the from the sheet I am using, hopfully it…
-
Default properties for rows
I started a new sheet using the 'Template: Client Creative Brief'. I have subsequently changed most things, including the colors. However there seems to be default cell background color (dark blue, see QTY. column in attached screen shot) that shows up every time a create a new column. Does anyone know how this is set and…
-
Equipment Check-out...
Has anyone implemented a sheet for use as an equipment check-out form? That is a web form that is filled out by the user which allows them to select from a database of available equipment and indicate the length of use in days? I think I could do that with a column dropdown list populated with the items that are available.…
-
Template Smartsheet
ID request row: * Within my Smartsheet template I have a field called Type Request: which contains the options to select: new request or change request. I need to relate all the changes that are generated for that project within the same ID request.
-
Configure Form
Go to section according to the answer within the form: How to configure within the form the possibility of showing a question, based on a previous answer?
