-
IF formula with allowable variance
I need to write a formula that will put Yes in the column if the Quote and Invoice values are within $5 of each other, or if the Quote Frequency is recurring. Here is what I have so far, but I can't figure out how to add the allowable variance of $5 =IF(OR([Quote Amount]13 = [Invoice Amount]13, [Quote Frequency]13 =…
-
Report not Matching Formula Issue
Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop: You will see on here that there is: * 3x for the FASTRACK Workshop * 10x for the Van Workshop *…
-
IF / OR formula help
Hi community, hope somebody may be able to help. I am trying to link a % of completion column with a progress bar. Formula is as follows: =IF([% complete]1 = "0", "Empty", IF(OR([% complete]1 > "0", [% complete]1 <= "0.25"), "Quarter", IF(OR([% complete]1 > "0.25", [% complete]1 <= "0.5"), "Half", IF(OR([% complete]1 >…
-
Linking Reports in different sheets
hi guys background: I work for an investment management company. Internally we have about 6 different reports that are interlinked in this manner Report 1: the starting point is an events or presentation calender Report 2: the actual presentation report, where feedback is gathered from presentations that come from the…
-
Applying new template sheet to old projects
We have a collection of projects that were created some time ago. Since the projects were created, the blueprint those projects were based on have had some additional template sheets added. Is there a way to incorporate those new template sheets into the old projects, either on a single project by project basis or in bulk…
-
import and consolidate daily changed excel file with SS sheet
Hi, currently my team (4 members) uses one excel file to save information about insurance incidents (task tracking with regularly action documentation f.e. what have craftsmen done, has insurance paid a.s.o). It takes a few month until we all may use SmartSheet. Until that time I would like to daily or weekly import the…
-
Card View by Contact List column type
Hi there, I have a sheet for tracking contracts and assign the contracts to my staff of 10. I would like to be able to have my swim lanes be organized/sorted by the "Contact List" column type (I have my assigned staff in this column). based on this help…
-
DAYS360 Formula
I'm trying to move various spreadsheets from Excel to Smartsheet but I keep needing the DAYS360 formula. It is very common to calculate loans based on 360 day years so monthly figures remain constant (at 30 days/mo). I was very surprised to see that this formula is not supported by Smartsheet. Is there a way to mimic it?…
-
Integrate with Bank Feed
Can I integrate a sheet with my bank (Lloyds) to automatically download new statement lines every 30 mins or so. I have to login to my bank and copy the data across all the time and would like to automate it if possible.
-
Capturing the Date and Time a Cell in Smartsheet was created or modified?
How can I capture the date and time the associate column in the above image was created and I want it to be in the date column. Thanks.
