-
Countif for Days Elapsed between two dates
Hi - I have a tracking sheet - it logs date when we receive a request and then a date when the request is fulfilled. I need to calculate how many rows in my sheet where the date rec'd to date of completion is 5 days or less - I'm doing this in a Sheet Summary field. I asked the AI for a formula and it gave me this:…
-
Start Date Formulas not appearing in reports
Hi community - ran into an issue I've never experienced before. Across all my clients, we use formulas to project dates (we've used durations/predecessors in the past, but it's not our preferred method). If we look specifically at the "TEST - SD - Internal Scope Alignment Call" line, you can see the "Start Date" formula,…
-
Assistance needed with the following formula...
I'm trying to put the correct data (person) in the correct column for an Employee and their Management hierarchy, using the following formula: =IF(VLOOKUP(Worker@row, {Active Workers Report - Mgmt Lvl}, 5, false) = "Team Lead", {Manager}, "") Can someone help me correct the formula, so the Name of the Team…
-
Formula to insert date and/or time
Hi All, Whilst I use a 3rd party app for shortcuts when typing, its fully functional in Smartsheet. I am seeking the formula to insert the date in a text field while typing. Example in MS Excel the formula is &[Date] however this doesn't work in Smartsheet. I use Smartsheet via Microsoft Edge.
-
Combine Contact Lists
Hello. I am trying to combine contact list A with the Created By column into one Contact Helper column to use in order to restrict the user view in Dynamic View. Here is my problem. Contact List A is filled in from a form submission. The user is supposed to enter or select their email address along with the emails of any…
-
Sharing lessons learned - hiding rows & columns - replicating formulas across sheets - disaster plan
Warning! Long-ish post coming your way with multiple topics I wanted to share. Throughout, if I’m missing a functionality whereby I’m needlessly fretting, please, please let me know. Intro Hiding rows and columns administratively across 20 unique Sheets Porting in and out of MS-Word for large find / replace formulaic needs…
-
Restaurar filas perdidas con datos adjuntos
Por error se ejecutó una automatización y se borraron todas las filas de una hoja con muchos archivos adjuntos, necesito recuperar todo y mantener el orden para poder continuar mi trabajo, ¿es esto posible?
-
COUNTIFS - count the number of dates that fall within one month
Hi Community! Hoping you can assist. Can you tell me what is wrong with this formula for counting how many publications that fall within one month? =COUNTIFS( [Publication Date]:[Publication Date], >=EOMONTH(TODAY(), -1) + 1, [Publication Date]:[Publication Date], <=EOMONTH(TODAY(), 0) ) The date in the Publication Date…
-
Formula result is "N/A". Automation does not seem to evaluate it properly
Hi, I have a formula in column C such that: =IF(ISBLANK(column A), column B, column A) column B is also a formula, and the result is sometimes N/A. In the column B formula this result is written as "N/A", so it comes in as text with no leading or trailing spaces. Also, column A, B, and C are all multi-contact columns. When…
-
MAX Formula Cells Updating in Reports
We have two cells with 'planned start' and 'planned end' dates. We also have two cells for 'actual/revised start date' and 'actual/revised end date'. These are designed to allow managers to enter the estimated start/end date of a milestone, and the revised start and end date when things slip. The actual/revised end date…