-
Using Addition and Multiplication in the Same Formula?
Hello everyone, I am trying to calculate an amount based upon the sum of two numbers. If you look at my screenshot, the highlighted Hotel and Transportation budget amounts are based upon the # of Days Onsite plus # of Travel Days. I need the system to be able to add those two numbers together and then multiply it by the…
-
Post api call to import into smartsheets. 502 error
Hi - I have an Excel sheet of data that I' m using to convert into json and then import into smartsheet. It is authenticated and runs fine till it has to actually import the data. It errors out at uploading the data with 502 connection was reset by a peer. I truly appreciate any/all help. Thanks Mythili
-
Numbers importing as Scientific Notation
I am working with PO#'s in a smart sheet and joining this data with a SQL database to combine a few tables. I use a visualization program called DOMO that I use to import the smart sheet data and the SQL data and join within the program to make one dataset. The problem I am having is when I import the smartsheet the…
-
Parent Row Roll Up
I am looking to create a formula that will do the following: If all child statuses = Complete, it will say "Complete" If at least one child says in progress or complete, the parent row will say "In Progress" If all child statuses say Not Started, or are Blank, it will say "Not Started" I tried using this as a shell:…
-
IT Portfolio Rollup
Hi Community, There have been numerous posts about how to essentially rollup multiple smartsheet projects into a portfolio/dashboard to show overall status information about the portfolio. I get the essence of the various posts, but before going down those paths to figure-out how to build something from scratch, I'm…
-
Calculating a day from a date
I've got a column (called "Dates") formatted as dates. I would like the adjacent column to show the day of the week that date falls on. Using the formula =text((Date1), "dddd") brings back an #unparseable error in the cell. I've tried using brackets instead of parenthesis but it hasn't worked. I must be messing up the…
-
How To Build Report Based On Created Date
Hi everyone, I really need help of your expertise. I have develop one form and its purpose is to collect Facility Manager (FM) daily inspection on each floor. I have created one column "Created_Date" just to monitor new submission from FM. As you can see in "1.JPG" Each Question has yes, no and N/A answer. In "2.JPG" is…
-
OpenAir Plugin?
Is there a plugin to OpenAir? https://www.openair.com/index.pl
-
Smartsheets Sending Mobile App Notification, but Not Email
I have a conditional alert set up in my form to send an email every time a row is added. When I use a form to add a row, it sends me a notification on my phone through the app, but it isn't sending me an email. I checked my spam filters and there is nothing in there being held. Has anyone else had this issue? This form is…
-
Loss of Tabs
Can someone please explain to me the reason for removing the sheet tabs and changing it to what we currently have now? I understand changes that are less user-friendly up front if they provide an overall better experience or increases the functionality and capabilities of a program. However, in this case I see absolutely…
