-
How to populate valid resource rates from a source table, for each week of a project.
I have a Resource Table with… Resource ID Name DailyRate ValidFrom R01 Resource X $1,500 3/8/25 R01 Resource X $2,000 9/1/25 R01 Resource X $2,200 9/31/25 I also have a Week by Resource Table with… WeekID ResourceID WCDate ValidRatePerWeek W01 R01 3/2/25 auto-pop $1,500 W02 to W26 R01 All the dates for W02 to W26 auto-pop…
-
Based on frequency selected change the formula for the created date.
I feel like this should be super simple but I am just not getting it right. Based on Frequency: Daily, weekly, monthly I want to change the next due date This will be calulated from Created column and +1, 7, 30 etc added. It works single instance =IF(Frequency@row = "Daily", Created@row + 1) but as soon as I try to write…
-
Need help with Index formula across sheets
I have a Master sheet that I would like to source information to subsheets for Project columns, of which then the % complete and date complete on each subsheet gets Indexed back to the Master sheet. However, I am needing to add 2 lines on the Master sheet to populate on all of the subsheets, but when I assign them unique…
-
Help to link health status formula to status
Hi, Need some help here is my current formula for health status in project plan. =IF([End Date]@row = "", "", IF([Summary Helper]@row = 1, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", ""))), IF(Status@row = "Complete", "Blue",…
-
Projects releasing today + 60 days
Hi all, I have a formula such: =COUNTIF({project rel +2mos}, >=TODAY(+60)) that is returning a 0 count, even though there should be a count there. I do have the specified column I'm calling set to "Date". Any help greatly appreciated!
-
Multiselect Dropdown Formula for multiple combinations
If multiple selections are an option from a drop down column, is there a simple way to write a formula that will display a different result, depending on the combination of item(s) selected? I was able to get the formula to display the result for one combination, but how do I nest each of these individual formulas into one…
-
New to Smartsheet and completely overwhelmed - how do I manage trials with multiple tasks?
This is what I would like to accomplish using Smartsheets but I am struggling to find the best way to go about it. Each year we get new vegetable varieties that we need to test in various locations at different times. I would like a tool that I can follow each variety up with a grower. The following data is added:…
-
Adding cells with IFERROR blanks
I'm having an issue with this sheet: Smartsheet - Quote The COST / PC column is where the issue is happening. On line 4, I'm testing out using a different material that doesn't conform exactly to the sheet's setup but I'm trying to build in functionality to make it possible. When the columns being added by COST / PC are…
-
Creating a Gift Card Inventory and Transaction Log
Hello! I am attempting to create a gift card inventory log and a transaction log. I created a master sheet to house the general inventory. I also created a transaction log. My goal is for them to talk to each. The master sheet will house all of the gift card information like, the serial numbers, description/store, value,…
-
Created Date by column to show on line entries only
Hi How do i set created Date column to only show entries from line 24 downwards?