-
Auto filling a Formula
I am using a formula to do a COUNTIFS based on Dates, a drop down YES/NO column and a name. I am wondering if it possible to auto fill the name portion of the formula from another cell. The formula looks like this: =COUNTIFS($Date:$Date, <=DATE(2017, 6, 30), $Completed:$Completed, ="Yes", $[Assigned to: Editor]:$[Assigned…
-
Vlookup with cross sheet reference
Can someone please provide an example of the Vlookup formula with the cross reference? I have tried both formulas below and get errors on both. =VLOOKUP([New Job Code]1, {Lot Status Report - Goldmark Range 3}, {Lot Status Report - Goldmark Range 3}2, false) #UNPARSEABLE =VLOOKUP([New Job Code]1, {Lot Status Report -…
-
Monthly Turnover Time
Hello, I am working to create a widget on a dashboard. In order to do this, I want to get data between a start date and end date (turnover time) per month to show monthly progress. I have tried by finding the month and year but I'm not sure how to attach the turnover time days with its corresponding month/year . . .…
-
Dashboard Auto Counter - Help Please
I have created a dashboard that I want to display the number of ideas created (and maybe count how many in each status). I am using a widget to link to a value in a sheet. My sheet I am linking to is called 'Summary Metrics'. I have an idea tracker (simple grid sheet), that has a Status column with eg: 4 status options.…
-
Unable to Copy and Paste
Hey all, I am currently unable to copy and paste text from Microsoft Outlook into Smartsheet. I can copy and paste text from within Smartsheet forms, but cannot paste text from any other sources outside Smartsheet. I was able to use this function until it suddenly stopped working yesterday. I utilize this function every…
-
Grid to Card View
Is it possible to create a project plan in Grid View and have it seamlessly transfer to the Kanban board on Card View? The hierarchy on the Grid View impacts the display of cards on card view. See attached screenshots. Ideally, I want to enter the project plan in Grid view and then have all the tasks show as cards in Card…
-
Formula for multi-cell status update
Hi all - First Discussion here. I am trying to use a formula that will populate a cell with "Not Started", "In Progress" or "Completed" based on the condition of eight cells in the same row have data in them or not.I have created two formulas that work in part but cannot figure out how to properly combine them.The idea is…
-
Access Cell History Modified Date in a formula?
Is it possible to access the stored date of cell's modification in a formula? I need to send email notification when a process is marked complete by a user. I see that I can view the cell history, and there is clear documentation of the date something changed, but if I could access that data in a formula in a new cell to…
-
Macro or VBA funtions
I'd like to be able to create a macro or VBA code that would allow me to create a job folder on our local server using data from my smartsheet. The VBA code in Access looks like this: Private Sub cmdCreateCaseFolder_Click() If Dir("\\MA021SFS01\NorthEast_EWP\2018CaseFolders\" & Me.Project# & "-" & Me.Project Name & "-" &…
-
Multiple Selections from a Drop Down
Hi, am creating a smartsheet to collect certain client information & documents to provide a certain service. While creating a form which could be sent to my clients, I've realised that it only allows for a single selection of a document off all the documents that I've listed in the drop down. However I need multiple…
