-
Pin sheets to top of workspace
Hello, I have a Workspace that will soon have several dozen sheets or more. I have a Template for this Workspace and a Smartsheet on how to use the Workspace for my organization. It is going to get very easy for these two important sheets to get lost. Is there a way I can "Pin" them to the top of the list?
-
% complete based on count of completed pieces
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 looks at duration vs. actual amount of work completed. Can someone offer guidance?
-
How to show time delays on a Gantt Chart?
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 able to visually show to the clients (via a Gantt Chart) the reason (weather, power,etc..), the length of time (Start Date,…
-
If function for issue flagged
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 red when an issue is flagged or checked and it is not working. Can any one please help. =IF(Status2 = "In Progress",…
-
Embed certain columns on another page?
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 tool to document and report statuses, would like to embed this gannt view but exclude the column with notes so it's a cleaner…
-
Pen/tablet devices for writing entries into smartsheet
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 into a tasks list, or responses to a checklist in the same way they do with a paper pad and pen now. Most will still use…
-
Dynamic Future Date based on Condition
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 Draft/Negotiations", add 60 days to the "Phase Modified Date" (60 days that will dynamically update everyday, so today will be…
-
Completed Row Drops To Bottom
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 they are still working on?
-
MAXIFs Alternative?
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 in the material price columns I have an Index/Match formula to display the most recent entry for that material. I would like…
-
Procedure for implementing SS Time Card Template
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 them for payroll to view. We have a dozen or more field employees that work various customer each day and would be tracking…
