BobbyLite

Comments

  • I dont use SQL myself so I am not sure if it will work for GC4676 but I saw there was a connection between Smartsheet and SQL Server which is why I suggested it...
  • Instead of referencing Design3 could you reference another cell that contains the value that would have been in Design3? So rather than value_if_false = do nothing it would be value_if_false = show value from this cell. Maybe add a new column (even hide it later) that contains all the values that would have been in Design,…
  • There are a couple options for this... The easiest would be for you to share your CSV file (email it to them) and they can import it to their accounts. The other option if you are on a team or enterprise plan, add the users to your account as free (or paid) users. Then whenever anyone in your account assigns a task to a…
  • Weekly notifications will send out on Fridays, so if that works for you then you can use the notification you have set up. You could also set up a recurring update request which can include ONLY the attachment column. It will say "Please update my online sheet." in the email rather than "here is the attachment" but you can…
  • Cell linking will be the only way to link data from one sheet to another but it sounds like this isnt what you are looking for. Are you trying to pull in data from multiple sheets to build formulas off of or just to consolidate into one location? If you want to consolidate, I would recommend using reports which can pull in…
  • Predecessors can be used to do this as well. Link all your tasks together with predecessors then add lag/negative lag days where needed (-60 days, -45 days, etc). Then all you need to do is add your first task date and all the other dates will automatically calculate.
  • Depending on what calculations you are trying to make, you could use the formulas the bottom right of the report. Highlight cells in a report and automatic calculations will appear at the bottom right based on what type of data you selected (min, max, avg, sum, count, etc)
  • 你可以使用他们PI to build a custom solution or use applications like Zapier which allows you to build rules using their API (no coding requred) Info in API: //www.santa-greenland.com/developer
  • There isnt a way to change the default from what I have seen. You will need to resort each time you open the attachment menu
  • I just tested this by opening a new sheet created from 4 Month Project Launch with Gantt and when I changed the dates on row 3, all the dates under it changed as well. Did you delete any predecessor values or did you turn off dependencies? All the dates are linked together using predecessors so if you removed the values…
Default Avatar