-
Gantt chart that overlays multiple projects
We are trying to see if there is a way to view a Gantt chart that overlays projects that are in multiple sheets so that we can make sure our department is not spreading itself too thin/which projects have overlapping timelines. Is there a way to accomplish this?
-
Smartsheet to Word Document
One of the ways, we utilize Smartsheet it is track the publications that come out of research. A few times a year, we are required to report on all publications and they need to be formatted in a specific way. Is there an option to transform a row into a Word friendly version v. the information being in row format.…
-
Email User Completed Form
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
COUNTIF in Sheet Summary
I am using this simple formula in a new field in Sheet Summary & I keep getting an "Unparseable" Error. =COUNTIF(RESPONSIBLE ENTITY:RESPONSIBLE ENTITY, "FIRM")
-
Sheet exceeded the maximum recommended size
Has anyone received this error message before? What are the options for large data?
-
Ranking Tasks
I work in the IT Department at a company. Another department assigns tasks to our department for software support for a particular application that they use. We would like for them to rank the tasks that they want us to complete - with numbers - 1 through 25, for example. If they create a new task for our team and assign…
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
-
Collaborators
We currently have a team account and it appears when I add collaborators to the sheets, when they accept the smartsheet and setup in smartsheet with a "free trial" I then get calls from them that their free trial is expiring, In addition, under their free trial they are able to move columns and edit the sheet, which they…
-
Join Collect
Hi i'm trying to find all of the timekeepers that worked for a specific client. Normally I would use Index Match however, there are multiple time keepers that worked for the client and index match only shows one name. For Index match I use the following formula: =INDEX({TimeKeeper}, MATCH([Matter Number]1, {Matter Number},…
-
Cerco freelance italiano per assistenza
Cerco freelance italiano per assistenza
