-
How can I create an autonumber field that only increases when the column "Hierarchy" = 0?
What I have tried so far but is not working: =IF([Hierarchy] = 0, MAX((IF([@[Hierarchy]] = 0, [@[AutoNumber]]))) + 1, "") =IF([Hierarchy]@row = 0, COUNTIFS([Hierarchy]:[Hierarchy], 0, ROW([Hierarchy])@row , "<=" & ROW()), "") =IF([Hierarchy@row ] = 0, COUNTA([Hierarchy@row ]) + 1, "")
-
Summary Sheet Formula - conditions
Hi Wizards, I use a lot of formula including summary sheet formula for use in dashboards. SUMIF and CountIF are great but here is my problem (bear with the long explanation) 3 departments fill in a daily form and select Area (Stoke, CC or Transport) and then provide 4 or 5 pieces of information all through a form. This…
-
How can I calculate and display a percentage ratio between two numeric columns in Smartsheet formula
I have a Smartsheet with two text/number-type columns: Credit Consolidated Credit Required by Proposal I’d like to add a third column (Formula type) that divides Credit Consolidated by Credit Required by Proposal and shows the result as a percentage string (e.g. 130%). Smartsheet doesn’t offer native percentage formatting…
-
A cross reference formula that was working before suddenly stopped working
I maintain a weekly project tracking system across two sheets: Sheet 1 (Project Status): Contains detailed project status updates Adds 20 new rows each week (one per project) Includes a 'Snapshot Date' column to identify the week Sheet 2 (Status Summary): Tracks project status counts (on-track/off-track) by week Previously…
-
Looking Up Value Based on Date Range that a Date Falls In
Hi I'm looking to create a lookup that uses a date field (pub date) and then pulls a value called Selling Season based on the date range that pub date falls within. Current formula that isn't working: =INDEX(COLLECT({Selling Season}, {Pub Date Start}, [Pub Date]@row >= {Pub Date Start}, {Pub Date End}, [Pub Date]@row <=…
-
Help with formula
This discussion was created from comments split from: Extracting Data From Cell.
-
Is it possible to connect Sypro to Smartsheet?
Our client wants to connect Sypro to Smartsheet so they can only have 1 reference without duplicating/transferring the information from Sypro to keep from doubling the effort.
-
Formula Help: Sumifs, based on multiple values and excluding one value
I'm struggling with my Sumifs formula, where I want to return a sum value based on two conditions and a further third condition that excludes a certain condition. I can get the first bit working, but I'm struggling to exclude the status 'Cancelled' from the calculation. Can anyone help advise where I'm going wrong please?…
-
Executing multiple conditioned automations with one trigger.
Hey Folks, Basically, I am looking to use an automation (or other tool) to check and fill multiple cells based off of a single checkbox. Specifically: When ticked, check Col 1, if Col 1 is empty, write HELLO. Then check Col 2, if Col 2 is empty, write HELLO. Then check Col 3, if Col 3 is empty, write HELLO. And so on. The…
-
Why does the Sheet Summary SUMIFs formula show a different result than my report?
I am using this formula to report the total $ amount of past due projects, which rolls up to a dashboard for our team. =SUMIFS(Fee:Fee, [Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "1-Pre FMV Info Request") + COUNTIFS([Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "2-FMV In Process") + COUNTIFS([Key…