-
Date and/or time stamp solution
We use Smartsheet in many wonderful ways but, in my opinion, the lack of a method to easily lock a cell with a date and/or time stamp is an open door for a competitors raid. A few years ago, I left Smartsheet because images could not be exported with line item details and there was no "key" to associate with a file export.…
-
IF AND date issue
Hello, I hope you can help please. We use Smartsheet to prioritise our workload. What we want to do is to highlight if a task is due this week but we have not manually indicated it as a priority for this week. I have written an IF AND to use a red indicator if the conditions above exist and green if not. It seems to work…
-
E-mail notifications
Hi, I have a 'Sheet' named 'Main sheet' with forms submissions arriving all the time, within the 'Main sheet' there is a field called 'Employee Department', when populated from the form this looks up the 'Project Sponsor' from a further 'Sheet' named 'Lookup' and pulls the e-mail through to the 'Main sheet' - this all…
-
Replicate Excel Formula in Smarsheets
Any tips on getting this formula from excel working in smartsheets? =EDATE(A2,VLOOKUP(MONTH(A2),'Data Table'!$B$3:$C$15,2,0))
-
Count formula with cross sheet reference/criteria
I’m sure this is easy and I am missing something fundamental. I have searched other conversations but can’t debug my formula. I have a detailed project sheet (that is at max capacity…therefore I have created a separate sheet to do some counts so I can create pie charts and dashboards. I’d like to count the number of sites…
-
COUNTIF Function
Hi All, I'm looking for assistance with COUNTIF if possible. I have a smartsheet containing 3 Rows of multiple flight departures. I need to create new columns which will count the following cells for me: Departure Flight Number Departure Date Flight Arrival Time All of the cells are completed, however when using COUNTIF, I…
-
Alerts For When Nearing 5000 row Limit
Is there a way to set up an alert on a sheet for when it is nearing the 5000-row limit? Thanks!
-
Need to formulate long date imported from form into a reportable date in Smartsheet
I have a form (not Smartsheet and unable to convert to Smartsheet form) that populates into Smartsheet. Dates come in long form (I.E. September 30, 2019), which means they are not reportable in Smartsheet. I need to get the long form date into a date format Smartsheet recognizes so I can run reports off of it. I have tried…
-
How do I add text to the end of a formula?
I have a formula that calculates the number of days and would like to add the word "days" at the end of the formula. In Excel, I would use '& "days"' as in =NETDAYS(Added1, Closed1)&" days" ...
-
Red Flag If statement
I have an if statement that is doing what I need except when there is no value in the deadline column. I want to keep the functionality I have but make sure the flag is not red when I have no deadline set. =IF(AND(Deadline2 < TODAY(2), Completed3 = 0), 1, 0)