-
Dynamic Data in a Drop Down List
I know you can up type in a list of values into a drop down list but can a drop down list be dynamically populated with data from another column? Can you use values in one column (column A) as input to a drop down for another column (column B) . By reading the data in column A and populating a form's drop down list in…
-
Alert from webform entry not working
We use a webform to enter new orders into Smartsheet, and need a notification to go out to several team members when one is to be rushed. All team members receive other alerts from changes in that Smartsheet, but this one that needs to be driven from the moment of order entry isn't working. Here's a screenshot of how it is…
-
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…