-
Regular Expressions (RegEx) with FIND function
Hi Team, I'm guessing that SmartSheet doesn't support regex in formulas as I get an #UNPARSEABLE error when I try it but I thought I'd better post the question here before I make that assumption. I have the following text in my "Subject" column: [1751] - Guide Posts With the formula: =MID(Subject1, FIND("[", Subject1) + 1,…
-
Filtering out data from an equation
Hello, Is there a way to filter out specific data items from an equation? Specifically I am creating a sumifs formula and I would like to be able to filter out fiscal year data without making it a condition of the formula, that way we wont have to change the formula every year. I have a column that shows the fiscal year as…
-
Can sheet EDITOR make sheet "invisible" for a period of time?
I have a sheet for which I'm the owner and I've shared it with 10 people in a workspace. I have one collaborator whose permission level is "Editor -- can share" and I'd like that person to be able to temporarily "check out" or make the sheet invisible to other users while she's making her changes/additions. I know that the…
-
RSS Feed
Hi All, I have a question regarding RSS feeds. Currently, I am utilizing Zapier to have a Google News RSS feed add new rows to a sheet. Then I generate a report so that I can have widget in Sights with news from the past few days. I've found that there could be hundreds of news articles a week, which will use up the 5000…
-
Assembly + Inventory Tracking
I've created a smartsheet to track every unit we sell of one of our particular product lines. The sheet includes the unit's serial number, model number, client name, client PO number, internal 'project number', current location of unit (Ex: "On order", "Johnny's bench", "Software dept.", "Warehouse", "Shipped - En Route",…
-
Smart Sheet Freelancer Required
Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to create reports.and sights. You should be able to use the advanced functions of cell linking and formula to create forecasts.…
-
How can I have a Timesheet?
I appreciate your recomendations.
-
Status RYGG Automated Formula
Hello, I am trying to create a status column which updates automatically based on the following criteria: * Green (Task is Complete): “% Complete” column = 100% * Yellow (Task is In Progress): Today’s Date is less than “Planned End Date”, and “% Complete” is less than 100% * Red (Task has not Started on Schedule): Today’s…
-
Project Parent Hierarchy not shown in PowerBI
Hi there, I am trying to connect Smartsheet and PowerBI, so that I can visualize data in PowerBI from Smartsheet. I have the connector working, and can pull data from Smartsheet, but it pulls the basic data (row level) for all rows with no way of distinguishing a child row to a parent row. So where I have roll-up…
-
workspace access question
I have a workspace shared with another user but she is not able to create a folder in my workspace. Additionally she is not able to add a sheet in my folder either which is inside of the shared workspace. Is there a setting I need to change or is this how it works?
