Formulas
Discussion List
- Hello everyone, Already grateful for your assistance in advance. I'm having some trouble coming up with a formula that can determine how often a multiple-choice topic appears in a column. I've used th…
- I created a formula that looks at the created time and date and checks a box if the hour is after a certain time if the day is a certain date. When the box gets checked, it means the entry was made la…
- My data input sheet has several columns that are Multi-select dropdowns. For my Metrics summary page, I am struggling with COUNTIF when the user has selected multiple options. Example of options in th…
- Hello all, I'm relatively new to smartsheet and excel and was hoping to get some help automating part of my sheet. I also have a bad habit of going about things the most complicated way possible, so t…
- I need to create a sheet/template where the due dates of tasks are based on the project's due date (i.e., I want to "back into" the project due date). I assume formulas or helper columns might be nece…
- Hi, This is probably really basic and I’m sorry if it is, but I’ve been tearing my hair out over WHY SmartSheet is complaining about this formula: =IF(AND([Raised by]@row<>”My Name”,[Raised by]@row<>”…
- I am a beginner in Smartsheet and have formula phobia but have been tasked with generating metrics etc. I have an ongoing intake sheet that collects details from volunteers on how much they get paid. …
- I am creating a series of sheets in a workspace. The idea is that there is one master log that feeds other logs as it is updated. The child logs would be fed once a condition on the master log is met,…
- I have one column set up with a dropdown menu and want another column to autofill with a specific value tied to each dropdown menu selection. Is this possible?
- I've built out the following workflow to notify our PMs of any newly inserted row AND change cell value on two columns in added row. The workflow is not sending notifications during my testing, but ha…
