-
Displaying multiple column values in Calendar view
I am storing data related to issues in the smartsheets. How can I show the issue number and priority in the calendar view?
-
Administration controls
Greetings, I am looking for advise. I am new to Smart sheets and my Operations manager no longer works for my company and she is setup with all of the administrative controls. I need to gain administrative control of the account. can anyone assist me in this?
-
Master Schedule
We have a a master sales information sheet that imports from our sales software and then links out to individual client sheets. Each of the the client sheets links to the previous job via cell linking and predecessors, We then have a portal that includes a gantt view of a report that we look at for scheduling - see…
-
Signed Approvals
Hello Is anybody using some form of signed approvals and how does one set it up? Do you use different apps and/or integrations etc? Regards
-
Reports - pdf or Excel ?
I send regular reports to customers showing their expected delivery date of products. These dates can change frequently to suit their own construction schedules. Some customers prefer Excel format, others prefer PDF. If I need to change the email address of any customer, or add another name to their team, I am unable to…
-
Dashboard
I am trying to create a widget on Dashboard for project progression that includes factors such as "Total development cost to date" "Total development cost this calendar year" "Future spending in next 1,2,3, months". How do I program the cells in sheets to reflect these dates (ie. todays date plus 20 days for next months…
-
Auto Assign a Predecessor in Gantt
Hi, I have a series of standard processes that have the same dependency and predecessor data each time. I have the primary column as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.). If pre-assembly is selected, for example, I always want it to…
-
Formula to add two columns together that meet the same criteria
Hello, Need some help with a formula, I am trying to add two columns that meet the same criteria from one sheet to total on another sheet. I have tried Sumif and sumifs formulas but they both comeback with errors Here is what I need: On sheet 1 I want to total columnA and columnB on sheet two if they meet (this) criteria.…
-
Concatenate two cells
Hi, I need to concatenate data of two cell into one cell. I just use the formula "=[Cell1] + [Cell2])", which worked fine and gave the result "Cell1Cell2", however I need to have space or underscore between values of two cell like, "Cell1_Cell2" or "Cell1 Cell2". My practical requirement is: I need to concatenate "date"…
-
Construction Submittal Log
Does anyone have a good construction submittal log template they wouldn't mind sharing? Thank you!
