-
Automation to set a checkbox when a number of days is exceeded
I added three columns to my issue tracking smartsheet: "Date set to Accepted/Cancelled" (date) "Days since set Accepted/Cancelled" (count) and "Hide from reporting" (checkbox). Then I set up two automations: Record date when status changes to Accepted or Cancelled (it works), and When "Days since Accepted/Cancelled"…
-
Using the holiday parameter in workday function
=IF(Runs@row = "Daily", WORKDAY([Completed Date]@row, 1, {Holidays Range 1}), IF(Runs@row = "weekly", WORKDAY([Completed Date]@row - (WEEKDAY([Completed Date]@row) - 2), 5, {Holidays Range 1}), IF(Runs@row = "Monthly", WORKDAY(DATE(YEAR([Completed Date]@row), MONTH([Completed Date]@row) + 1, 1) - 1, 1, {Holidays Range…
-
Introducing an OR statement within a COUNTIFS conditions succesfully
Hello community! This question may seem basic, but I would say is a common headache across users. I am trying to do a COUNTIFS function that takes into account that a specific name is in either one of three columns (as COUNTIFS create AND statements between the conditions). I introduced an OR statement at the end for that,…
-
Automatically Export Data from a MySQL Database
Hi, I need to automatically import data from a database, which is a MySQL into Smartsheet. My admin tells me that DataIUploader wouldn't work and DataShuttle doesn't have databases as a source option? Does SmartSheet have a tool to automatically pull data from a MySQL database? Thanks in advance.
-
Sheet Summary - same sheet VLOOKUP with TODAY()
Hi, My Column Headers are: Date, Total Opened Cases, Total Closed Cases, Total Backlog. I am attempting, and failing, to use the following variations of a VLOOKUP formula. Can someone help?? =VLOOKUP(TODAY(), {Date}:{Total Backlog}, 4, false) = #UNPARSEABLE =VLOOKUP(TODAY(), {Date:Total Backlog}, 4, false) = #INVALID REF…
-
Is it possible to create an hourly recurring task?
Hello, I am trying to create a task that would recur hourly, and check or uncheck a box whether it has been completed in that timeframe. Is this possible?
-
UNPARSEABLE ERROR MSG FOR SUMIF USED IN 2 SMARTHEET files
Somebody, please help. I tried all the different formulas. I m using two different files. need to multiply the specific unit total PO quantity. Formula is =SUMIF({SMARTSHEET COMPRESSOR PO Range 2}, ''USM2309103702'', {SMARTSHEET COMPRESSOR PO Range 1}) Thanks
-
Update Parent Row with Child
I have several budget sheets that are managed by separate functions. I want the leads of each function to update their data within their own respective sheet and for the updates to flow into one collated Master budget sheet. The Master budget sheet is linked to the individual function budget sheets using a unique…
-
Cross-Sheet Reference Syntax - Range vs. SheetName|ColumnName
I'm trying to master Index-Match referencing. To do so I followed the example in SS content-Center - https://www.smartsheet.com/content-center/best-practices/tips-tricks/3-formulas-look-up-data-smartsheet I created the tables used in the example, but ran into syntax problems. The basic formula they give is:…
-
First Day of the Prior Month and Last Day of Current Month
Hello! I have a date (A below) that pulls as expected. In B, I'd like to grab the first day of the month for the prior month and then C would be the last day of A. I have room for additional helper columns as needed to make it work. Thanks, Community!