-
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?…
-
How do I display the username of a modifier of a specific column?
I am attempting to display the username of a specific column using an automation workflow. I want for a user to be able to scan a barcode into column A, and for their credentials and time/ date of the barcode scan to be displayed in the next two columns. However, I want the credentials and time to be displayed of the user…
-
SUMIFS/VALUE
Hello, On sheet A, I have 2 columns (among many others) . Column1 contains a LEFT-formula that returns 3 digits. Column2 contains a LEFT-formula that returns 3 digits plus a hyphen and then 2 more digits. On sheet B I have a SUMIFS formula that references sheet A. If I reference column2, it works. If I reference Column1 it…
-
Need help with date reporting formula
I have 4 formulas in seperate cells that look at open and closed actions and does a count of how many there are for those months. The current formula for the current month:- =COUNTIFS({Date opened}, >=DATE(YEAR(TODAY()), MONTH(TODAY()), 1), {Date opened}, <DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1)) works fine and has done…
-
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…