- MM/DD/YYYY Date Format
Since there isn't a MM/DD/YYYY date format built into Smartsheet, I created a formula in order to create this date format. Please see below: =IFERROR(IF(MONTH(Date@row) = 1, "01", IF(MONTH(Date@row) = 2, "02", IF(MONTH(Date@row) = 3, "03", IF(MONTH(Date@row) = 4, "04", IF(MONTH(Date@row) = 5, "05", IF(MONTH(Date@row) = 6,…
- JAVA SDK - Update a Multi Picklist
Hello, I am having trouble updating the value of a multi-picklist in my sheet. I am using the Java SDK smartsheet-sdk-java 3.1.1, on Java 17. I am setting the column value with the following code: Cell c = new Cell(column.getId()); c.setObjectValue(new MultiPicklistObjectValue(List.of("All", "Some", "None"))); My column I…
- COUNTIFS with an OR in it
Hi Community! I am struggling with the below COUNTIFS formula which basically has to have an OR logic in it... =IF(Date@row <= TODAY(), COUNTIFS(OR({Status 1}, "Complete", {Status 11}, "N/A"), {Planned End Date 1}, <=Date@row, {Parent Child 1}, "Child"), "") There must be a syntax error, but I can't find it. Any hints or…
- Timelines - multiple work streams
We need to collect, and summarise timeline info in several streams a) Activities by group, relating to their workstreams (seasonal busyness) b) Org wide activities (i.e.long term and annual plan etc), c) External factors relating to staff availability (school holidays etc) This is to aid in selecting best timeline to…
- Data Shuttle - just want to add new rows
Hello! This is probably a silly question but for some reason I am really struggling with it. I want to just add new rows to an existing sheet.. pretty simple.. but for some reason the unique identifier requirement is throwing me off. What do I do in data shuttle to just add new rows from an excel file to an existing sheet?…
- Reference flag from one sheet in another
thank you in advance. how do you write a formula that looks at another sheet for a condition present in one column and then look at another column in that sheet to see if it has a flag? appreciate you!
- How to pull data from a report to a sheet?
I'm currently trying to create a sheet where I can pull data using a formula from a report, I've tried to do DataMesh & Pivot to no avail, would there be any way or formula where I can use a report as a source sheet? Also, can DataMesh mimic a report instead of a sheet? Thanks!
- Predecessors
If I already have 1 predecessor column, how do I create additional Predecessor column for different task. For example I have a predecessor column created for dates. I need another one created to calculate cost for different columns. When i enter the contract amount, I want the sheet to calculate when I enter a change order…
- Cannot Figure Logic or Syntax for Nested IF, AND, and OR formula
I have been unable, after 4 straight days of trying, to figure out this formula. I am a novice with Smartsheet. I need a Finding Overdue column (checkbox type) to report if a finding is overdue. Closed findings are automatically not overdue. Open findings have a deadline; however, the deadline may be extended, in which…
- SUM(COLLECT/SUMIFS( based on multi-select
Hi everyone, Does anyone have a formula already handy that does this? Looking to SUMIFS values where the variable is one of the options in the dropdown value? This is a cross sheet formula pulling from a table where there is only one country per cell, but looking to aggregate (show me everything in this region).
