-
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…
-
Workspaces Pros & Cons
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 mind sharing your insights and experiences? Due to the nature of the individual projects of "Client A", with time frames from…
-
Embed a smartsheet iframe into Google site?
This seems like a no-brainer, and maybe it has to do more with google's secret jealousy of SS, but why the f*#k can't I embed a SS iframe into a Google Site that I make for the company? This seems like the first thing any joint venture between google and SS would ensure possible. Can you please help?! :-)
-
Short Interval Schedule
I am having some troubles making something like this in Smartsheet. It shows manpower throughout a project. Any Ideas how to structure a Smartsheet that would make it easy for the eyes? Gantt chart could be nice but how would i show the change is strength based on time? Thank you.
