-
Formulas with multiple inputs in smartsheets. Help needed!!
This has been a challenge for me to figure out using the smartsheet platform. I am developing what is essentially a big calculator. The formula that I am trying to implement is: [($26,000 * DTH) + (Risk R * Repair Cost) + (Risk A * repair cost)] * frequency). In this database, each row represents an additional input. The…
-
Help. COUNTIF
I have been trying to find the correct formula for my Smartsheet. I need to create a count of how many people have been approved, denied, in progress, or have an incomplete application. I need to pull this from another sheet. Any ideas?
-
Automatically updated the TP Name
hi ALL, I am currently trying to build the chart that show all the status of all trading partners. There are many trading partners per customer and i have run the formula that extract the list of them. However, Now i can't automatically check the status of each trading partners and i have to write the name of the trading…
-
AGAIN, .... please help, I would appreciate an answer!
How to pick just certain tasks, but still keeping the correct timeline? Porzel Hans ✭✭✭✭ Dear all, I have a project plan that contains a number of tasks. In this project plan is a column, called "Necessity". It's a checkbox. Some tasks at the project plan are necessary, some are not, depending if the checkbox is checked or…
-
CountIf Day is between Start and Due Date
I'm stumped in this formula... I wish to perform a countif when a date is between two dates. I have a Start Date and a Due Date Column and in another sheet I have a list of days. and I want to count how many times the day June 07th is between Start Date and Due Date In the case below June 07th should be counted as 1, June…
-
Month and Year from a Date - #INVALID DATA TYPE
Hello Super Smart Guys! I am struggling with month and year extraction from a date. The date is extracted automatically as raw data from salesforce, please refer screen: Based on answer from this community, I was able to extract Date Only and remove hour, formula used: =LEFT([Date/Time Opened]@row; FIND(" "; [Date/Time…
-
How can I add a colum with the Estimated percentage of progress
Currently, I have my percentage of " completed work". However I would like to know , how can I calculate the " estimated percentage of progress". I mean. Today in one activity I have as "%Complete" an 80%, however accoring to my work plan by today in theory I should have that task at a 100%. How can I add that column to…
-
Trying to Sum a column with a condition and date range
Hi all, I am trying to Sum a column with a condition and date range where vacancies range 1 is the column to be summed, range 2 has the condition and range 5 is the date range. I've tried the below formula and it comes up as unparseable. Can someone please assist? =SUMIFS({2023 / 2024 Vacancies Range 1}, {2023 / 2024…
-
How to count tasks completed after a certain date.
I need a formula to count the number of tasks completed this year (2023). The column is titled Date Completed, and my formula is this: =COUNTIF([Date Completed]:[Date Completed], ">12/31/2022") It is showing the answer as 0, but there are 9 items completed. I also tried using 1/1/2023, but it still doesn't work (still get…