-
Formula for if checkbox is ticked
Hi I need to add a formula on the end of this formula please. I need to add if 2026 investment list is checked too. This is the formula =COUNTIFS({Exec Sponsor}, FIND(Metric@row , @cell ) > 0, {Intake Status}, FIND("Project Approved", @cell ) > 0)
-
Reminder Automation
Hello everyone, I need help in this!!! I’m trying to set up an automation where a reminder is sent to the contact list 1–2 hours after a row is added to the sheet. Is this possible in Smartsheet? If so, could someone please help me with the setup? Thanks
-
How to calculate the number of submittals completed each day.
I am currently working on a construction project where I am tracking Request for Information (RFI) for our subcontractors. I can get up to 30 RFIs a day. My question is what is the best way to track how many I process daily? Is there a Countif formula or a DataMesh process that works best?
-
Auto Create Schedule Based on Needs
Does anyone have a template that can create a schedule based on needs? For example: we enter the number of contacts calling us per hour per day and how long the calls take, how long it takes us to answer, the service level we want, list of full time and part time techs with their normal hours they work and a two week…
-
Extraer la Hora de 2 o mas celdas
Buenas tardes, como podria extraer la hora de registro de 2 ó mas celdas? o como podria registrar la Hora en una celda?
-
Date/Time field should be Date&Time field
Timestamps are only included on Created Date and Modified Date but it is useful to have a specific timestamp that will not update every time the row/sheet is modified. This would be a huge help especially when using the Duration field or other formulas. Either update the Date/Time field to include the time like Created…
-
Status to red once the deadline is reached.
Hi everyone, I’m trying to automatically change the Status to red once the deadline is reached. I placed the following formula directly in the Status column: =IF([Ende]@row <= TODAY(), "Red", [Status]@row ) However, I keep getting the error #CIRCULAR REFERENCE. My understanding is that this happens because the formula is…
-
AVG Collect Divide by Zero error
Hello, I am stumped again. I am looking to average data from another sheet and am getting a #Divide by Zero error, even though I believe the formula is written to ignore zeros and blanks in the data. What am I missing? =AVG(COLLECT({Indirect Project Summary -Avg Leadtime}, {Indirect Project Summary - Executive Sponsor},…
-
How would I add in a month based off a date in another column
Hi, I am needing to create a column that will display the correct month based off a date in another column. My columns are below. I am not certain on which formula to use. Thanks for the assistance!
-
Sheet Summary formulas
Hello - I am trying to run a basic fomula on my Sheet Summary cell and am absolutly stumped! Are there limitations on how we can use formuals on our Sheet Summary cells? What I want to do add any rows from the weighted ECV column that have 2026 in the Year column. I think this formula should work, correct?…