-
Formula to change text in a cell, if the date has passed the date set in another cell, ignore blanks
Hello all, I'm trying to create a formula that will check the target date against the date completed, and return "Late" if it's late and "On Time" if its not. This formula works as intended except that it lists all blanks as "Late". I have limited experience with formulas, and only the simpler ones. =IF(AND(ISBLANK([End…
-
Monte Carlo simulations for risk analysis and scenario planning
Does anybody have experience with running Monte Carlo simulations for risk analysis, scenario planning through APIs/integrations or APIs with Crystal Ball, Minitab, Excel, anything?
-
Workspaces Without Owner or Admin
We had an administrator leave our organization and we transferred their items to another owner. But now we have several workspaces which are showing there is no owner and only Editors. So we cannot edit anything in these workspaces. Has anyone else had this issue? I have reached out to Smartsheet Support twice this week,…
-
Smartsheet Updates Via Excel - Live Data Connector
My understanding is that at this time, there is no way to update data from Excel, and it have it show up in Smartsheet. The Smartsheet Live Data Connector provides a read-only experience and is not able to write data into Smartsheet. I would like to propose an idea for Smartsheet to be updated via Excel.
-
Using Attachments in Automation
Hi, I've created an automation that sends an approval request with an attachment in a row. However, sometimes rows will have multiple attachments not related to the approval, and I don't want those sent. Is there a way to specify which attachment will be sent to the approver?
-
Document Builder to generate one document from two sheets, but attach to one of them
Hello, I have a quoting solution I am working on, and due to the level of complexity wrt all the calculations for the quote, I am using an input sheet (one row per quote), and an output sheet for all the calculations. When the quote has been completed, I would like to use document builder to create a PDF summary of the…
-
COUNT IF duration between two dates & return 0 if one column is blank
I'm trying to count a cell if it meets the following criteria: Termed Date - Hired Date = > Hired Date or if Termed Date is blank, count if Hired Date = > today's date
-
Current User Filter
Hi I have a report that is filtered by current user. The sheet contains requests people submit via a form. I have set the form that allows submissions without the user being logged into smartsheet and this appears to be now giving them a number (see screenshot of filter below) This is now causing my report filtered on…
-
Weekly Data Capture to other sheet
I have a metrics sheet "Request Metrics Sustaining" that can tell me live how many tasks I have in each status that is in our process. On a separate sheet I want to get a snapshot of qty of tasks in each status weekly to have a running list. What's the best way to achieve this?
-
Hi! Can someone please help me with writing a formula for my summary field?
I need to count rows if “Target Start” is between the Friday before last Friday and last Friday, “Work Type” is "EMERGENCY”, “Work Order” does not contain “IMP”, “Status” is not one of “Cancelled” or “Closed - Out of Scope” I've tried: =COUNTIFS({Target Start}, >=TODAY() - WEEKDAY(TODAY(), 2) - 2,{Target Start}, <=TODAY()…
