-
Predecessors (Finish to Finish & Finish to Start
I may have a basic misunderstanding & need some clarification. I have a task #3 (the Effective Date) of a contract. Further down the project I have another task.... #20 - Purchaser obtains an updated Survey & Title Commitment. Task #20 can begin on the Effective Date (task #3). Further down the project I have another task…
-
Sum if of Current Week +/- 1
I have a formula that will give me the current week capacity: =SUMIF(@{Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}). However I'm not sure of the formula to capacity for the next week or the past week capacity =SUMIF(@{Week Number}, @cell = (WEEKNUMBER(TODAY()) +7), {Capacity}). I would greatly appreciate some…
-
Column Search
I'm looking to create a total data sheet that gives me the total spreadsheet for the current week, next week and previous week, from data from another worksheet. The problem that I have is that the dates are the column names, does anyone have any suggestions on how to accomplish this. Currently I just highlight the columns…
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Table of contents in a large sheet; use of forms
hi, I use one large sheet to manage many different legal tasks across my team (1,000 rows currently). The sheet is divided to many sub sections/categories, main tasks, sub tasks etc. Wanting to add a new main task to a category, the user needs to scroll down to find the right category which is time consuming. Two questions…
-
Can it be done? Creating a workflow with a form from a seperate spreadsheet.
Hello - I have setup a sales pipeline spreadsheet and a separate proposal tracking spreadsheet. I would like to create a automatic workflow in the sales pipeline sheet so that when "Proposal" or "Pitch" is selected as a status in the pipeline a automatic workflow takes place to present the form for the proposal tracking…
-
Countifs based on current month turnaround times
Good Morning! I am trying to create a graph based on the current month's turnaround times. I tried the following, but it returns as #Unparseable. =COUNTIFS({Turnaround}, <=3, {Date Fufilled}, Value(@cell) = Month(Today)) Is this even possible? Thanks
-
Dragon Naturally Speaking
Does anyone else use Dragon Naturally Speaking when entering data into Smart Sheets? My expience has been negative. I can go to any other website, and enter text etc. However, SmartSheets does not allow for text to be entered in this matter. I am forced to use dictation box transfers, which is sort of a pain. Thoughts
-
Capturing user/email addressing via form
Relatively new smartsheet form user here. Is there a way to create a field that would allow the entry of a name in one column and an email in a second column and have a user input multiple name/email pairs within a single web form? Essentially, we are creating a web form for training sessions and there are a number of…
-
Managing Alerts & Reminders
Recently there have been a lot of changes to managing alerts. They have been very good changes. However, today I noticed that I did not receive an alert that normally would come to me. Upon checking I discovered that menus have changed. There is a new heading called "Automation". This took me a while to figure out. I…
