-
How do you Set-Up Reoccuring Tasks?
Hello! I am new to Smartsheet and I am trying to take all of my tasks listed in Outlook to form my personal Sheet for my schedule. I have many tasks that I repeat weekly, is there a way to form these in the sheet? I do not want to have to list the tasks every week, I will if I need to but wanted to see if there was a…
-
Complex Date Rx for a Schedule - Need Guidance
I have about 60 events, each with a Start Date and an End Date. Each event is either 1-day, 2-day, 3-day, or 5-day in duration. Depending on where the event is located it is to be replicated every 2 months, every 3 months or up to every 6 months. I only want the event to happen Mon-Fri and I don't want it to occur on a…
-
Amount of Working Time Between Tasks
We have a desire to calculate the amount of work time between the end date of a task, and the start date of it's successor task. Before the update that included partial day durations, we were performing this with simple date arithmetic. Now, that arithmetic does not hold true, and we need to devise an updated formula to…
-
Linked projects and Resource management
I have built what I am calling a master project sheet. it has projects as well links to other detail project plans. When I invoke the resources allocation (icon) from the "master projescts" sheet, I do not see all the resources allocated within the hyperlinked project. Is there something I am missing to get the "linked…
-
Hiding Completed Projects in Task Report
Good morning, I'm creating seperate reports for each of my users which pulls in all of their tasks. I'd like to remove or hide the tasks that have a '100%' listed in the '% Completed' column. I've added the '% Completed' column to my report and set up the 'What?' to exclude anything in which the '% Completed' cells contain…
-
Sorting within filtered view
It would be useful to be able to sort within a filtered view. I do realize that I could probably do something with Reports, however, we are looking at getting the Basic plan, which doesn't support Reports.
-
Web Forms size of input boxes can they be changed
Hi I am looking for help can i change size of an input box ?
-
Formula Help Error Message NETWORKDAYS
New user of SmartSheet and not too adept at Excel. I am trying to make a formula IF/AND so that there is no error message in a cell that uses the NETWORKDAYS functions if there are not dates in the two source columns. E.g., Job Complete-Est and Job Complete-Actual only have a date in neither or one So, if there is not a…
-
Limited number of sheets
My 30 day free trial just expired and I upgraded my membership to basic so I could continue to develop some workspaces in smart sheets. I didn't realize with this membership I would be limited to only 10 sheets. I need to have a workspace for templates (up to 20) and then need to be able to manage each client within a…
-
I would like to send my sheet to users for viewing purposes and only want them to have the ability t
I'm sharing my sheets w/ external vendors and want them to view all the data but only update their comments (1 specific column). 1) The update request does not allow the abiity to change some fields from edit to view only. 2) The update report is ok but does it send a request to the spreadsheet owner? So far i'm not…
