Hi, I'm running a project where I want to report our the % completion of a sub task based on the # of pieces completed. I'm thinking I need to create a formula as the % of completion functionality loo…
We are a construction company using Smartsheet to follow the progress of the construction on site. Sometimes delays occur due to weather, power, etc.. but not all trades are affected. We need to be ab…
Dear, I just wrote the below formula that update the status with RYBG indicators. however, I am having issue with the last if function of the formula "Flag Issue" part. I want the status to change to …
Is there a way to publish and embed a sheet's data onto another page with only certain columns? Example - Sheet has Sprint milestones and Notes column with Gannt view. We are using Confluence/Jira too…
Has anyone used pen/notepad based devices for making entries into smartsheet? We work in site construction and maintenance projects and it would be great for supervisors to walk around, enter actions …
Hello, Issue: I need to create a date column that will produce a forecasted date, based on a manually entered date plus X amount of days, based on a certain value (phase). Example: If Phase is "SOW Dr…
Hi everyone, While at Engage18, I heard there would be a way to have a row drop to the bottom of the sheet, once completed. Does anyone know if it's at all possible right now, or is this something the…
I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then …
I am considering proposing that our company try using the SS auto approval time card process. I am wondering what process the SS Community uses for the employees to access the time cards and store the…
I have read many posts in regards to how to use Workspaces, but I am having trouble locating a list of pitfalls, and/or situations where Workspaces may not work, compared to our situation. Would you m…