-
Join Column1 with corresponding Column2, 3, 4, OR 5
Hello - I am looking for help with joining the Department column with its corresponding Sub Dept column. The Sub Dept columns were split out by Department to be able to use logic on a form. For example, if the Marketing Department is selected, only show MKT Sub Departments as available selections on the form. I'd like the…
-
Help with formula: if Status is X and End Date is in X days, change symbol to X
Hello - I am looking for help with a formula that states: If "Status" is not "Complete" and the "End Date" is 5 biz days or less from today - change symbol to Red If "Status" is not "Complete" and the "End Date" is within 6-10 biz days from today - change symbol to yellow If "Status" is "Complete" OR the "End Date" is 11+…
-
Auto Populate Dates and email to Form
Hi All, i have smart sheet form with dates, and i want to populate the date as per status dropdown. once the status changes the date should auto populate to the form date field. also, is there any way i can auto populate email id's in form field whenever new user is going to submit responce. i have set automation to send…
-
Tracking Days of the Week Using a Symbol Column
Hello, Trying to see if there is a way to incorporate the progress bar option in the symbol column to track days of the week. Ex: If today is Monday, the bar would be empty, but if it was Wednesday, the bar would show as half full and Friday the bar would be full. Is there a formula that can accomplish this?
-
Resource View doesn't have the correct Allocation %
I am creating a Resource View that my team can use to track work allocation. It works, but there are several places where the data is not accurate - the allocation % on the Resource View does not match the allocation % on the project plan. For instance, in one Smartsheet, we have a task for 1 hour, which comes out to be…
-
Formula for multiplying with rounding included
Okay, so I need to come up with a formula that does 2 things: Multiples the numbers in ColumnA with the numbers in ColumnB Rounds those numbers up or down depending on what the nearest .5% is For example: ColumnA has 6 in it ColumnB has 70% in it Multiplying those together, gives me 4.2. I need that to automatically round…
-
Count # of issues with the same Assigned Date
I have an issues tracker with Status drop down column and an Assigned Date column noting the date the issue was assigned to someone. I want to count the total issues by Assigned date that are in specific status, i.e.: Open, Client, Retest, etc. Looking for something that says Status = Design Change Date= 10/5/22 Count = 10
-
IF Statement based on Date
Greetings Community I'm trying to build a formula that gives me different results based on the date in one column, but one of my weaker spots is always the nested IFs. To give you context of the expected result: I have a column that tracks the different dates of Contract renewals and I want to add a new one that gives me…
-
Input form for multiple sheets
I originally had an Excel worksheet with multiple tabs. The first tab was an input sheet which fed into 100's of formulas in the other tabs. The other tabs (one for each country) used the values from the input sheet to do the numerous calculations. In Smartsheet, I imported each tab (input sheet and each country). I also…
-
SUMIFS or SUM(COLLECT) With Cross-sheet Reference
I'm trying to total up hours from a timesheet for each individual across multiple projects. I've tried the following two formulas but both are returning 0. SUMIFS({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row, {Timesheet SOW}, SOW@row) =SUM(COLLECT({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row,…
