-
Are you able to hide specific rows from people on a shared sheet?
Hi, I am working on building a sheet for our CEO to track employees tasks and deliverables. However, he wants 1 sheet with multiple viewers (the team) and to be able to make the sheet so that each team member can only see the tasks (rows) they are assigned to and not be able to see any rows that are assigned to other team…
-
COUNTA alternative in Smartsheet
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and two of the columns have a rather complicated formula, which has a function I don't believe is available in Smartsheet (COUNTA). When I've tried to replicate it I get an error message (UNPARSEABLE) The formulas are:…
-
Calculating Days
Hello How do i get this formula to Calculating the numbers of Days when i select the date columns. e.g I want to select the dates and then it calculates the number of days from the two date ranges selected.
-
Data doesn't match the data from Excel when replicating formulas
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and I've been able to recreate a good portion of the columns that have complex formulas, but there seems to be a number of discrepencies with some of the data where it is out by a few thousand pounds or a couple of percentage…
-
Create dynamic custom schedules based on selections in intake
Hi all, I recently developed a cool solution to an issue that we had... how to build a custom schedule based on selections in an intake form. This solution leverages Bridge, but you could do the same thing using a third party integration tool. THE GOAL The process goal for this solution is: Collect project requests using…
-
Save as new//100 sheet limit - work around?
Hi - Does anyone have a workaround for this? I have a client where i have stripped the workspace back to around 150 sheets - they need to be able to replicate this workspace. I'm getting the same error message when trying to copy the workspace via the API - The end result means that due to this limitation, someone has to…
-
Sheet Templates
I'm new to the Smartsheet Planning group for our team so I'm coming in after years of them doing things a certain way. I'm trying to find a more efficient manner to manage updates to master sheets instead of rolling them out quarterly as we've been doing. Essentially every quarter we pull all feedback, make updates to the…
-
IF and ISDATE Formula
I want to calculate NETDAYS from Submission Date to Todays Date, or to Comments Log Received Date I have this formula that works. =IFERROR(IF([Comments Log Received]@row = "", NETDAYS([Date Submitted to SJTA]@row, TODAY()), NETDAYS([Date Submitted to SJTA]@row, [Comments Log Received]@row)), "") However, I need to expand…
-
Merged: A way to see which reports a column has been added to
This discussion has been merged.
-
How do I customize the Strategic Plan template so the project request form attaches to a project tas
I need assistance customizing the Strategic Plan template to the needs of my department. I don't understand how the project request sheet connects to the project A & B Task sheet. I created a form for the team to submit their strategic initiatives for approval. Once a strategic initiative a approved, how does it auto…
