-
Update Request single use link
Does anyone know if there is a way to allow a recipient of a "Send update request" to use the same link more htan once to update a particular row? An installation within my organization is a single day event but can span the entire day. I may need multiple check-ins from my field tech. Today, I send an update request to my…
-
Starting a task based off of a column selection
Sorry if this is covered elsewhere and if it is can someone send me a link? Basically we are setting a sheet and are hoping to auto add a child row based off a column selection. Ideally we could choose what if any to prefill in it but even just being able to get a child row to auto add would be a huge help.
-
From one pipeline to another
Hi there, I have a new business pipeline we use for prospective accounts we are working on. Depending on what happens we either win, lost or are still waiting to hear - these three options are drop down boxes. They are also RGY colour coded. Is there a way to send a line to another sheet (pipeline)? I.e. if we are…
-
Incorrect resource management visual
Hello, Has anyone seen the issue below where the visual bar shown in the resource view does not match the working days? Mine are set to Monday - Friday (Individual days below are fine),but the top summary bar always shows Tuesday through Saturday. Any thoughts? Thanks!
-
gantt chart export
in the title, everything is said. need help please :) don't know how to export to have my gantt chart on word, that would fit the landscape page but still visible cheers for any help
-
Search Function not working
Today, for no apparent reason, my search function will not work. It hangs and eventually times out with an error. I've rebooted my MAC and closed and reopened Smartsheet. This is talso rue for another user attempting to search the same Smartsheet. I am in the middle of a critical project that requires Smartsheet data that…
-
Exclude values based on formatting
i.e. exclude red from a SUM function, so all the red values are not added up
-
How to use a range of numbers in a formula
Hi SmartUsers, I have a formula to show bars according to the completion % of a cell. The formula is: =IF(Completed?9 = 1, "Full", IF([% Complete]9 = 0.25, "Quarter", IF([% Complete]9 = 0.5, "Half", IF([% Complete]9 = 0.75, "Three Quarter", IF([% Complete]9 = 1, "Full", "Empty"))))) It'll show 1 bar if a task is 25%, 2…
-
Recommended Master Project Document?
Is there a recommended method for tracking multiple projects? A master sheet or doc that shows the status or project of multiple projects? We've done some basic sheet linking but there was no status update and it was fairly manual. It would be great if there was a way to create a line item in the master project document…
-
Syncing Smartsheet Calendar with Google Calendar
Hi I would like to sync my smartsheet calendars with a google calendar so that I can have one centralised calendar for all of my sheets. However, when I sync them, I loose the conditional formatting (which I use to colour code the different types of tasks/appointments in smartsheet). How do I maintain the colour coding?…
