-
Task Manager Master Sheet
Hello - I have various Microsoft Forms creating new rows with requests to different Smartsheets using Power Automate. I'd like to create a "Master Task Sheet" that creates a row with a request ID, Smartsheet name & link, employee name, requested date and "done" checkbox. Could something like that be automated? Or should I…
-
SUMIFS Returning Zero?
I am trying to sum all hours that meet a certain criteria (match the lookup column/project ID). My Formula: =SUMIF({0 | Affiliate TESS HOURS}, [LOOKUP COLUMN]@row, {0 | Affiliate TESS Lookup}) {0 | Affiliate TESS HOURS} --> references "Entered Hours" {0 | Affiliate TESS Lookup} --> References "Lookup Column" Formula is in…
-
Issue with IF AND formula
=IF(AND([Engagement Phase]@row = "COMPLETED", [Production Status]@row = "Production Ineligible"), 0, 1) The formula is not working completely. I think i need to add an additional clause/check. Engagement Phase dropdown column with "In progress", "On-hold", "completed" etc statuses. Production status column with values "In…
-
Count of At Risk
In my sheet summary, I'd like to get a count of "At Risk" flags. What am I missing from this formula? To add, if possible, I'd only like to count the CHILDREN (not the parents) =COUNTIF(CHILDREN([At Risk]:[At Risk]))
-
Return multiple rows of results based on one row elsewhere
I'm trying to convert collected information on team's schedules in office into a calendar view to represent it. The data is collected as 1 row per week (checkmark if in the office of Week Start on X Monday). However, converting that into 1 row per day each Team is in the office (to be able to represent in the calendar…
-
Formula to figure out % allocated
Hi, Is it possible to calculate % allocated based off Estimated Hours/Total Work Hours within the date range (start-end dates) of the task. For example, Task 1's Estimated hours for completion is 10hrs and the date range is 10/17/2022 to 10/21/2022.
-
If conditioning formula
I am trying to create a condition formula that yields red or green under the following conditions If total A(forecast) is equal or higher than 10% of total b(budget) then red, less than 10% green. However I am also dealing with negative growth compared to budget, I need to show show if the negative growth is between -1% to…
-
Open Balance Aging Columns
New smart sheets user here. Can anyone point me in the right direction to have a aging column on this accounts receivable sheet that shows how long from the invoiced date it has been? Exp..1-30 days, 30-60 days, 60-90 days and so on? Then I need it to also know when the open balance goes to $0 so it’s not showing something…
-
Is it possible to have users use a form to search for a line item and auto send an update request?
I have a SmartSheet that lists contracts with fields that include contract end date, purpose of contract, vendor contacts, etc. This information needs to be updated by the manager who is responsible for the contract, but I don't know which of our managers are responsible for which contracts to update. Is there any way to…
-
How to Apply formula to dropdown columns
Production Status- drop down column- with values like In-Production, Production Ineligible etc Handoff Column-dropdown column- with values 1,0, N/A Contract Signed -Dropdown column-with values 1,0, N/A Need a formula that if for "Production Status"-Production Ineligible is selected from the dropdown then Handoff column and…