-
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.
-
Simple Sum formula not working
I'm running into an issue where it appears the formulas that I have returning a number are not available for simple math in sum formulas. Any suggestions? For example, I have a column that produces the month a project will close based upon the estimated completion date currently linking in from the individual task lists. I…
-
Free Collaborator / Unlicensed User
Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row. secondly: if Unlicensed User delete row or related information in row how the admin will get to know what happend or what is…
