-
COLUMN CHART COLOR
Hello! In a column chart, can we change a specific column color since it is still a pending information, and we would like to highlight it. Merci.
-
Help on formula: format numbers and shorten to K (thousand), M (million), B (billion)
Hi all, So I was able to get help around here on how I could turn amounts in thousands and millions to just K and M instead of displaying lots of zeros. Now I would like to add a formula in to just round it up with just 2 decimal places and to shorten billions too. Can someone help please? Here's my current formula:…
-
Automate sheet creation
Can I use automation to trigger the creation of a new sheet? Here's the situation. I have a form that adds a new row to a sheet. I would like to evaluate the primary key's value against what already exists in sheet and do one of two things: if the value already exists add the row to the existing sheet for that primary…
-
Sharepoint site refused to connect in work apps
Hello , this embed SharePoint page stop working last week. I don't have any issue accessing the SharePoint original page. I guess this issue is related to Smartsheet workapps application. Does anyone know what it could be?
-
IF/AND/HAS for 3 column references, 6 options
Based on the content above for reference only, the actual sheet screenshot below. I need a formula or help with a helper sheet/workflow, to bring back one of 6 results. (above image) Tax Status Column is a dropdown with the 2 options shown, Bottling Location and Entity Columns are INDEX(COLLECT formulas (if it matters)…
-
Seeking Help from the Smartsheet Community - Document Management and Training Matrix
Dear Smartsheet Community, I'm reaching out to seek your valuable insights and experiences, as I'm currently working on two crucial projects within my organization. Document Management: Our current document management system involves a mix of various tools, spreadsheets, and shared folders. While it's functional, it's not…
-
COUNTIFS between dates & criteria.
Greetings Smartsheet Community, I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame. So far I am successful counting the dates in the range using the following formula: =COUNTIFS({Range 1}, <=DATE(2018, 4, 31), {Range 1}, >=DATE(2018, 4, 1)) Next I'd like to add…
-
SUMIFS with 9 criteria
I am trying to sum specific values based on a dropdown list in one column and display that sum in another column. I have an "Amount" column , a "Total Final OEP 0708 Cost Center Spent" column , and a "Cost Center" dropdown column. I want to sum CHILD rows in column "Amount" based on the drop down option that is selected.…
-
Retrieving Ancestor (date) value from multi-level parent-child rows
Hi All, I used the following formula to retrieve ancestor (first parent) date value of the multi-level parent-child rows for each row. =LEFT(INDEX(JOIN(ANCESTORS(Date@row), ","), 1), 8) The issue that I'm facing is the return value being "TEXT" despite having "DATE" column type. Since I have to use this return value in…
