-
Sequential Numbers "IF"
I have a project management template that I am trying to set up with a column to produce sequential purchase order numbers only if a column named "ORDER DATE" is populated in specific category rows I have named "ORDER MATERIALS". Can this be done? I am not too good at formulas, so the more specific, the better for me in…
-
Smarsheet data share over mobile no instead of email
Hi everyone At present I am sharing data with others over their email addresses. Is there any method of sharing data over their mobile no? Say user has a what's app installed on their mobile and status update request or report can be shared on mobile?
-
If a checkbox
Hello again. I need some help please with automation/formula on a project management sheet we use. (Action 1) I have a checkbox column called "SNAGS" When this is checked, I need a date column called "SNAG ADDED" to auto populate the date in which the checkbox was ticked by the project manager. (Action 2) Like wise, I have…
-
COUNTIFS formula not returning result
Hello Community! I have a COUNTIFS formula that does not return an error, but it also does not return the result I am expecting. Long story short, I am trying to count how many projects we plan to start by month and year. There are three separate columns that I am pulling from. The column that is giving me troubles is the…
-
What the best way to manage 8,000 Projects in Smartsheet
I am new to Smartsheet and not sure how or if the program can help...I have project where I am rolling out a new program to 8,000+ locations and looking for way to leverage Smartsheet to manage. I know there is a 5K row so not sure how to proceed. Most threads talk about pulling rows out once complete but my project is a…
-
Counting party size from Symbols
I would like to use the party size symbol in a form for registration, but am not seeing a formula that would count the responses?
-
Feature Request: We need advanced functions to connect and control multiple sheets
I am a project manager at a construction company so we use Smartsheets pretty heavily for everything from vehicle mileage reporting to project forecasting. The single biggest improvement that I would like to be done for Smartsheets is for greater links between multiple sheets. We are thinking about migrating to Sage 100, a…
-
just signed up and wondering how to access the integration apps
Hi Everyone, I am a newbie to the smart sheet system and already loving what it can do. I am wondering how to go about linking the software to my office 365 account can anyone help me please
-
Shortcut button of sorts for a Project template
I have many projects in a Project Management workspace. The project sheets have a section to order materials for projects. I have a GRID Sheet in another section of Smartsheets that creates purchase order numbers and has a brief description of materials ordered. I would like a shortcut on each project sheet that would…
-
Assigning multiple people to one task (I see this has been asked before)
I read through some of the threads on this subject. It really is frustrating to not have this feature. One of the primary reasons we started using smartsheets was to have a living work schedule for our employees at my constuction company. I would like to create reports that show where an employee is assigned on a given day…