-
Sharing - keeping info confidential to relevant parties
Hello, My colleagues and I have a large database containing information regarding suppliers. I need to share the information that is relevant to each supplier, with that supplier. I can obviously run a report to pull the data out based on 'Supplier' column in our sheet, as there are a large number of suppliers on this…
-
If & AND equals checkbox
Cant get my formula to work =( Please help =IF(AND([Team]28 = "Street Lighting", (NOT(ISBLANK([Quote Sent Date]28)), 1, 0))) If Column 1 (Team) contains text "Street Lighting" and Column 2 (Quote sent date) is not blank, Check the box Thank you in advance
-
Formating in Smartsheet
Cell merge function I have seen that this function is still not in place. Can anyone tell me when this function will be implemented? Or is there a way, where I can use a text in one my Project templates with an instruction text to guide someone through within my template, for example my due diligence questionnaire (DDQ),…
-
Report - Finish Dates
I have a report I use which gives me all tasks in my projects that are overdue, due today, or due tomorrow. (A screenshot of the report builder is attached, below.) It stopped working properly yesterday, when I updated some dates but the task did not drop from the report. Today, it's showing tasks that are due a week from…
-
Report Sorting by Sheets Names Starting with Numbers Out of Order
Hello, I have a report being built off of 10 different sheets. Each sheet name is prefixed with a number and followed by the name (1. Project Name, 2. Project Name, etc). All was working well and the sheets were being sorted in the report by sheet name as expected until I came to sheet #10. Now the report sort order is 1,…
-
Scheduled Backup
I am trying to set up a backup on our main sheet (This one has info from other sheets linking into it) I am able to select schedule recurring backup for my entire workspace, but we don't need all of that. All we need is one sheet to be backed up each week. When I right click on the sheet it will allow me to request a…
-
How often does a report update?
We are using a Smartsheet Report to upload data into a third party system. We are curious as to how often the Report will update. Example: If we open one of the Smartsheets that feed the Report and make a change and we do not open the Report, then when the third party system pulls data from that Report, will it have the…
-
Automatic Countdown
I am working on a restaurant buildout project list, and want to have a column for "Weeks till Opening Day" and another for "Days till Opening Day". Is there a way to have that automatically countdown to a targeted date?
-
IF AND Formulas - Where am I going wrong
Morning All, I have been trying to work out a formula for a calculation, i am not very good at formulas so i cant see where i have gone wrong, can any one help please? I need the below: If today > actual start date & today is > actual end date & % complete < 100% = Red If today > actual start date & today is < actual end…
-
Sumif / Countif
Hi All, Still new to SmartSheet so help would be appreciated I am trying to sum a column if another column contains specific text "street lighting" I have come to =COUNTIF(Team:Team, "Street Lighting," ([Past Due Date]:[Past Due Date]) but it comes back with Unparseable and I am lost, It's probably something simple that i…