-
#Unparseable Error When attempting to use IF function
Hello Everyone, I am trying to write an IF function to automatically change the value of a certain cell for certain conditions. For some reason I keep getting the #Unparseable error when I type out this formula. =IF((NETDAYS([Date Need By] 6, Today())) < 3, [At Risk], [In Progress]) I have attached a screenshot of the…
-
Workflow Approval
Being new to smartsheet but an experienced systems developer I had set up a multi person approval for capital requests in smart sheet. It was quite ugly and ungainly and smartsheet was lacking features I have used in other systems. So I was very please to see the workflow approval functionality released which goes someway…
-
Removing Multiple Link
I have created and tested a few examples of the master sheet where it links data from two base sheets. The bases sheets are maintained by my team and I don't require any changes. I have successfully done so but due to me testing a few times, the bases sheets are showing, each cell, data is outbound linked to <unknown…
-
Calculating Totals
Dear all I deal with importing goods from all over the world, and payment usually happens in multiple currencies. In smartsheet, I have a column for currency (USD/Euro etc) and the next column I have the amount. What I am looking for is a payable total in each currency, E.G. For Payable euro, the formula will look at all…
-
Auto Date Calculation
Hi Very new to SmartSheet, I am trying to create a Purchase Tracking sheet that can be used for Payment Schedule. Here is what I have " Invoice Date" This I put it manually whenever I receive an invoice from my vendor. I also have another cell "Droplist" which state payment terms like 30/60/90 days. What i need is 1) A…
-
Limited Access to Report Builder
We have been using a very simple report to pull information from a single sheet. The report has been working fine for several months. Today I was notified (& verified) that I am the only person who can still edit the report via report builder. Everyone else is stuck viewing the information I last searched for and cannot…
-
Can I have the default value be a function?
I have a form that asks for someone's name. Most of the time, the form is for that person. There are some cases where a person might fill out the form on behalf of someone else. What I'd like to do is have a "name" field and a "on behalf of" field. If "on behalf of" is blank, I'd like it to default to the value of "name".…
-
Project Dashboard Generator
I am trying to develop a dashboard generator so that I don't have to recreate every report I use in our dashboards each time we have a new project. I would like to be able to select the project number in one location and have all the reports reference that project number to pull data from their respective sources, then…
-
Weekly Update Text Column
Hi Community— Need some advice. My team uses an Excel spreadsheet to track account updates. Weekly we add a column to the right and the team inputs a paragraph of text. So the existing Excel sheet is up to column "AH" since we are at calendar week W42. So next week ... "AI" and so on. The previous week's column is then…
-
Counting Harvey balls by row owner
One column of my sheet is a 5-symbol Harvey ball (Sunny, Partly Sunny, Cloudy, Rainy, Stormy) to show the relative health of a row. Another column is a Contact List type that shows to whom a row is assigned. I would like to extract the total number of non-Sunny rows per team member. What I have done is to add two columns.…
