-
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",…
-
Automatically add formula to new row & apply @row to look at row above
I have my cashflow forecast on Smartsheet, and i have a formula which looks at the balance on the row above to apply the balance for the current row as follows =BALANCE1350 + [in's]1351 - [out's]@row. When i shift the row up or down within the sheet, it keeps looking the the balance original balance on the row that was…
-
Register and calendar integration
Hi, I need assistance in creating a calendar which will show the number of locations where material deliveries will happen (5 locations) over 24 hours - 365 days a year. The idea is to then create a dashboard with the form and calendar and share it with the senior members of my team so that they can book delivery slots by…
-
Populate column with names by project
I'm wondering what the best way to do the following would be: I have about 100 districts and each one is assigned to one of four people. I want to populate a column with the names of the people associated with each district. Would this be best as a nested If statement? Thanks!
-
Form
I created a form some months ago and I need to expand it now by some columns, but the update just doesn't show for the user who is filling in the form. Can anybody help? Thanks!
-
Formula with multiple equations
I'm trying to convert a fairly simple formula from excel into one of sheets that has multiple equations in it and can't seem to find the one that works best. formula in excel would be =(B45*B46)+B45
-
Can I add something to color code for blank cells?
Hello, I am using the following formula to represent health color for individual rows: =IF([Start Date]40 > TODAY(), "Blue", IF(AND([% Complete]40 < 1, [End Date]40 < TODAY()), "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", "Green"))) This formula works well for what I need except that I use a template project sheet…
