-
Flag column based on date & other criteria
I'm trying to figure out how to set up an alert to automatically notify someone if the entry row hasn't met criteria (checkbox) within 5 days. I was thinking about creating a flag column that kicks off an email alert but I can't figure out the flag formula. Here's what I've been trying to play with: If [Created Date] is…
-
How to bid Materials - Construction question needing solution:
Hi Smartsheet, I have the following problem. I am a contractor that has to go around a home and take a materials count on a list of tasks say a door install, window install, etc. Anyways, I am trying to figure out the quickest and best solution to take a materials count for my given tasks and then fill in the info I'll…
-
Formula to auto calculate time difference in hours between two 24hr format times?
I'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format. Once picking their starting time and end time, I would like the third column, "Total Hours", to…
-
Need a visual dashboard/report to display 6 projects, and their upcoming tasks by month,day
Are there Portfolio or Program templates that will display tasks in a gantt chart or horizontal timeline view?
-
SUM totals of VLOOKUP
Looking for help on a formula. I need the Forecast Adjustment column on (A) to add all amounts pulling (B). These should total $13,416.67, however, it it showing as $5,416.67. Please help! How do I change the formula to sum the VLOOKUPS? (A): Forecast Adjustment forumla =IFERROR(VLOOKUP(Category@row, {Table Category_Full…
-
Help with an IF/AND/OR formula
Hello, I am trying to write a formula to return today's date when all of the following are met: Column 1 is not blank Column 2 is not blank Column 3 is either Kangaroo or Platypus If any of these is untrue, then I would like the cell to remain blank. Here is my attempt which returns an incorrect argument error:…
-
Pulling in data from external source
I work with large data sets on parts (60,000 SKUs) and I have a form and workflow for processing special pricing requests from our field. I'm curious if I can house the prices on an external excel file or sharepoint and pull in the pricing for an individual part. Since Smartsheet limits the row count to 5,000 I can't just…
-
Nest if/or formula
Hi Community, I need your help... I'm trying to create a formula that captures "No Action Taken". The individual IF Statements are as follows: If [Flu Vaccination Date] is "Blank" OR If [Flu Vaccination Date] is ">=" [Flu Vaccination Date]$1 OR If [Flu Declination Date] is "Blank" OR If [Flu Declination Date] is ">=" [Flu…
-
Is there any possibilities to get the Webhook data when someone make a request to access the sheet?
Hi, we are using Smartsheet's webhook API. We have the following use case. Consider user 'A' registered a webhook on a particular sheet. When some other Smartsheet user 'B' who has URL of the sheet of the user 'A' and tried to access the sheet its shows "Request Acess" and when the user 'B' clicks on request access, the…
-
Using COUNTIF to determine dept. but excluding projects that are HOLD Status
I can't figure out how to do this formula and I've been searching for it in community. I've tried the following: =COUNTIFS(Portfolio Rollups Range 1, "Corp IT",AND({Portfolio Rollups Range 8},="In Progress",{Portfolio Rollups Range 8},="Complete") This one returns unparsable =COUNTIFS({Portfolio Rollups Range 4}, "Yellow",…
