-
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…
-
Report Viewability
So I have created several Reports and have noticed that when you add them to a Dashboard, anyone with Dashboard Access can view them as a Widget; however, When made a viewer on the Report itself, all the people see is a blank page. Do the Viewers also need access to the sheet the report is pulled from? If so then reports…
-
If, Then Formula
Hi everyone, I've searched through the community but couldn't find the right solution. I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information on the 15th of each month, so the formula would need to cover a 45 day period. I added…
-
Moving Average
Greetings Is it possible to plot simple moving average on Smartsheet ? Thank you