-
Change Text/Number to valid date
I'm using a date in the primary column, of course Smartsheet sees this as just text/number. I've added a column called "Date" and want to convert the Text/Number to an actual date. Primary Column...........Date 1/29/2024....................01/29/24
-
Question on Metric Sheets and COUNTIFS formula
Hello! I was working on a metric sheet and it was working perfectly but then all of a sudden my whole table went into error - not sure what I did! Here is my formula: =COUNTIFS({DPM Programme FY24 Workstream}, [Primary Column]@row, {DPM Programme FY24 Status}, [Column2]$2) And here is my table:
-
SUMIF Formula for Multiple Criteria from Multiple Sheets
I want a tally of the results in {Master-# of Assets} and {VisionHub- # of Assets} from two different sheets (that are almost identical in columns) I want a formula that will give me this tally across both sheets with the condition that the Team Managing is in the Primary Column and the FY is in the [Primary Column]$2…
-
Total of Certain Value Across Multiple Sheets
Hello! Hoping someone here can help. I have 6 sheets that are identical in setup and parent rows (inventory for each vendor - Child rows are only varience being actual inventory). I'm needing a summary sheet that totals the quantity across each of the 6 vendor sheets. I've tried a variety of…
-
Need formula to check a box if another column is under < $1,000 remaining.
Greetings- I need a formula to select the Alert checkbox if the Remaining $ is under $1,000 left. One time Id also be curious if possible to do this based on a percentage left of the original PO Amount. ex If I have 10% of the original starting PO amount left. Thanks for any info! MD
-
How to ignore blank cells in health formula
I have a working formula for task health based on % Complete and Target Completion Date (see below). I'd like this formula to ignore any rows with blank Target Completion Date and display nothing in the Health column if there is no Target Completion Date. Right now it's defaulting to Red. I know I should add ISBLANK, but I…
-
Pre-Filled Form URLs
Hi SS Community, I created a formula that builds the URL below to pre-fill fields on a form using values from a table. The resulting string works when I copy & paste it into a browser window, but not when I click on the link in the Smartsheet table, the last field (Personal Email) is blank. Does this mean that there is an…
-
Calculate start date based off of end date
Hi All, Can someone help me with a formula? I've searched the community and haven't been able to find an answer. I already have a formula in place to calculate the end date based off of the start date and duration of project. However, if I have an already defined end date I'd like to calculate the start date based off of…
-
Checkbox with IF AND formula- satisfy two criteria simultaneously
Hi, I want to add a formula to a checkbox column, the purpose is to automatically check the box once the cell satisfies two criteria simultaneously. Criteria 1: Phase column=Milestone Criteria 2: Finish Date column<= 03/11/2024 I have tried a few IF AND formulas but still can't get the result desired, loosing temper now :(…
-
Could someone help me with this sheet summary formula?
I'm trying to create a formula that adds the amount in the "Amount" column only if the "Revenue Period" column contains "2024". When using this formula I get "0".. =SUMIFS("Amount", "Revenue Period", "*2024*")
