-
Copy Action Items to separate list when identified in Meeting Minutes
We are capturing individual action items with a checkbox in our meeting minutes sheet. Once actions are identified, we're using the "Link from cell in other sheet" to pull the data from the meeting minutes sheet and into the action items sheet. Since this is a manual step, we'd like to simply check the action items box in…
-
Stacked Bar Graph
Is there a way to create a stacked bar graph with the new charts? Thanks! Chase
-
Report Building
Hello, I am trying to build a report on Smartsheet using multiple sheets. Each of this sheet has atleast 30 rows. Is it possible to select rows while building these reports ? There is an option to choose columns. Howeever, I do not need all the rows present in the sheet. Is there any way to do the same ? Thank you
-
Help with IF AND formula
I appreciate the wealth of knowledge in this community. I have reviewed several scenarios around my similar formula, but still nothing is working. I continue to get #UNPARSEABLE. Hoping some expert out there can help!! The following formulas work independently, but I need them to work together and drive the RGYG buttons…
-
SmartSheet / ServiceNow interface
What is the interface between SmartSheet / ServiceNow and can it be an automated rather than a manual extract which can be extrapolated into reports from Smartsheet?
-
'Find & Replace' functionality in SmartSheet?
Is there a way to use a 'find and replace' functionality across the entire estate of worksheets through utilising Dynamic View coupled with Reports?
-
Can it be done? Creating a workflow with a form from a seperate spreadsheet.
Hello - I have setup a sales pipeline spreadsheet and a separate proposal tracking spreadsheet. I would like to create a automatic workflow in the sales pipeline sheet so that when "Proposal" or "Pitch" is selected as a status in the pipeline a automatic workflow takes place to present the form for the proposal tracking…
-
IF(And formulas to count late dates
I would like to create a formula that measures the health of a project (Red, yellow, green) with missing dates: Expected Date (June 6, 2019)- I assign that date to the vendor Scheduled Date (this is expected within 5 days of assigned expected date)- this is filled in by vendor Completed Date (this is expected within 5 days…
-
Formula for cells with multiple assignees
Hello, I have a projects list that allows multiple people to be assigned. What is a formula I can use that will count someone's name when a cell has their name plus other(s)? Thank you in advance. Formula will be used as a basis for a dashboard
-
Using COUNTIFs with FIND & AND
Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). Currently using: =COUNTIFS({Consultant…