-
Do not want Cells with "N/A" figured in my formula
=SUM(CHILDREN()) / (COUNT(CHILDREN()) + COUNTIF(CHILDREN(), "")) I am using the above formula for percent complete in my project plan as seen by my picture. My question is when certain parts of the project have not been started yet how do you exclude the cell with the "N/A" value in it from being calculated?
-
#Unparseable error
I'm using the system to monitor and report progress to our client. We do surveys on their sites and perform installations. On top of the sheet, I have locked 6 lines that I use for summaries of the totals with simple countif statements. Any ideas on why?
-
Add a Chart from Smartsheet Labs Charts on a Dashboard in a Workspace
Hi, Gentlemen. I created some charts on Smartsheet Labs Charts but i can't add them into my workspace on Smartsheet. How do i do that? Above is a print screen of the charts i created. OBS: I have already tried to upload via URL (URL and embed code). I was not successful. I need help guys.
-
Permissions to edit cells
Hello all. I have several work flow sheets, in which collaborators have to change the status of the tasks, but not all collaborators could change any status. The question is possible edit permissions on cells to avoid that any user could change it? Thanks
-
Arabic Language
hi we would like this platform to support Arabic Language as a GUI thanks
-
Match Statement with Multiple Sheets
Hi, Due to the limited restraints on the # of rows (5,000) in Smartsheet - I need to create a formula that references multiple sheets for a match statement. See below: =IFERROR(IF(MATCH(([Employee ID]1 + [Current Position]1 + [Training Name]1), {Completions(1) Range 1}, 0) > 0, "YES", "NO"), "NO") I have another sheet…
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
Sharing a Folder in a workspace
How can I share a folder with specific people in a workspace while limiting them from seeing other folders in the same workspace?
-
Welcome screen - non-enterprise account
I am the system admin for a business account. I'd like to create a dashboard (with useful links to the most relevant sheets, forms and workspaces) for all users to see when they first log in to Smartsheet rather than seeing the last sheet that they were viewing when they last logged out. From what I understand, a welcome…
-
Inventory
Is there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.